摘要:
表数目:select count(1) from sysobjects where xtype='U'视图数::select count(1) from sysobjects where xtype='V' 存储过程数: select count(1) from sysobjects where xtype='P'表详细信息:SELECT * FROM sysobjects WHERE xtype = 'U'C = CHECK 约束D = 默认值或 DEFAULT 约束F = FOREIGN KEY 约束L = 日志FN = 标量 阅读全文