select a.name as tabname ,h.name as idname from sys.objects as a right join sys.indexes as h on a.object_id=h.object_id where a.type's' go 由于索引和系统列没有直接对应关系 所以不能直接查看列字段和字段长度
select a.name as tabname ,h.name as idname from sys.objects as a right join sys.indexes as h on a.object_id=h.object_id where a.type's' go 由于索引和系统列没有直接对应关系 所以不能直接查看列字段和字段长度