SELECT sysCol.Name, sysType.name, sysCol.length FROM syscolumns sysCol
INNER JOIN sysobjects sysObj ON
sysCol.id = sysObj.id INNER JOIN systypes sysType on
sysCol.xtype = sysType.xtype WHERE sysObj.name =’nombreTabla’
Otro sitio realizado con WordPress
SELECT sysCol.Name, sysType.name, sysCol.length FROM syscolumns sysCol
INNER JOIN sysobjects sysObj ON
sysCol.id = sysObj.id INNER JOIN systypes sysType on
sysCol.xtype = sysType.xtype WHERE sysObj.name =’nombreTabla’