摘要:
SELECT a.name, b.rows FROM sysobjects AS a INNER JOINsysindexes AS b ON a.id = b.idWHERE (a.type = 'u') AND (b.indid IN (0, 1))ORDER BY b.rows DESC 阅读全文
摘要:
外键: 查询:select object_name(a.parent_object_id) 'tables' from sys.foreign_keys a where a.referenced_object_id=object_id('B表') 格式(名称):FK_A表_B表 A表是主表,引用B表 阅读全文