Per SQL Server

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')