Ritorna la dimensione delle colonne di una tabella

SELECT TOP 100 PERCENT tables.name AS TableName, cols.name AS ColName, cols.xtype, cols.length, cols.cdefault, cols.isnullable

FROM         dbo.syscolumns cols INNER JOIN dbo.sysobjects tables ON cols.id = tables.id

WHERE     (tables.name = 'LNET_SAP_WBEWBS')