sql server:
表: select count(1) from sysobjects where xtype='U'
视图: select count(1) from sysobjects where xtype='V'
存储过程: select count(1) from sysobjects where xtype='P'
转载于:https://www.cnblogs.com/Mander/p/3620893.html
sql server:
表: select count(1) from sysobjects where xtype='U'
视图: select count(1) from sysobjects where xtype='V'
存储过程: select count(1) from sysobjects where xtype='P'
转载于:https://www.cnblogs.com/Mander/p/3620893.html