SELECT QUOTENAME( sysobjects.name )
+ ‘.’
+ QUOTENAME( USER_NAME( sysobjects.uid ) )
+ ‘.’
 + QUOTENAME( syscolumns.name )
AS [Name]
, TYPE_NAME( syscolumns.xusertype ) AS [Type]
, syscolumns.prec AS [Precision]
, syscolumns.scale AS [Scale]

FROM syscolumns
INNER JOIN sysobjects ON syscolumns.id = sysobjects.id
LEFT OUTER JOIN systypes ON systypes.xtype = syscolumns.xtype
WHERE sysobjects.xtype = ‘U’

No tags for this post.