不常用的sql语句

1、  查找数据中的表名、列名、类型长度

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 '