摘要: 表数目: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 = 标量 阅读全文
posted @ 2014-03-14 17:31 火光闪耀 阅读(780) 评论(0) 推荐(0) 编辑