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