よく使われないsql文

SELECT OBJECT_NAME(A.ID) [TABLENAME], B.[NAME] COLNMAE, TYPE_NAME (B.xtype) COLTYPE,B.[length] COLLENGTH   
FROM sysobjects A

INNER JOIN syscolumns B ON A.ID=B.ID

WHERE A.xtype= 'U '