我想这个对有帮助!老兄试试吧!SELECT A.id, B.name AS TableName, A.colid, A.name AS ColumnName, CHColName = '',
(SELECT MAX(keyno)
FROM sysindexkeys F
WHERE A.ID = F.ID AND A.COLID = F.COLID) AS KeyNo, C.name AS TypeName,
A.length, Isnullable = (CASE WHEN A.isnullable = 0 THEN 'false' ELSE 'true' END)
FROM syscolumns A INNER JOIN
sysobjects B ON A.id = B.id INNER JOIN
systypes C ON A.xusertype = C.xusertype
WHERE (B.xtype = 'U')
(SELECT MAX(keyno)
FROM sysindexkeys F
WHERE A.ID = F.ID AND A.COLID = F.COLID) AS KeyNo, C.name AS TypeName,
A.length, Isnullable = (CASE WHEN A.isnullable = 0 THEN 'false' ELSE 'true' END)
FROM syscolumns A INNER JOIN
sysobjects B ON A.id = B.id INNER JOIN
systypes C ON A.xusertype = C.xusertype
WHERE (B.xtype = 'U')
where a.id = (select b.id from sysobjects b where b.xtype = 'u' and b.name = 'MSM_Counter')
就搞定了表'MSM_Counter'的字段谢谢啊甘,可惜我刚才把100分都给看看了
用这个内部存储过程可得到有关表的详细信息