select name from sysobjects where xtype in ('U','V')
select name = s.name +'.'+ t.name from sys.tables t , sys.schemas s where t.schema_id = s.schema_id
select name from sysobjects where xtype in ('U','V')
select name = s.name +'.'+ t.name from sys.tables t , sys.schemas s where t.schema_id = s.schema_id
转载于:https://www.cnblogs.com/baiqian/p/5906234.html