sql server 数表:
select count(1) from sysobjects where xtype='U' --后面可以接name='tableName' 查询是否包含某一指定表数视图:select count(1) from sysobjects where xtype='V'数存储过程select count(1) from sysobjects where xtype='P'本文共 272 字,大约阅读时间需要 1 分钟。
sql server 数表:
select count(1) from sysobjects where xtype='U' --后面可以接name='tableName' 查询是否包含某一指定表数视图:select count(1) from sysobjects where xtype='V'数存储过程select count(1) from sysobjects where xtype='P'转载于:https://www.cnblogs.com/wangpf/archive/2013/04/11/3014678.html