摘要： select s.[name] + '.' + t.[name] as tablename from sys.tables as t,sys.schemas as s where t.schema_id = s.schema_id and s.[name] = @dbo order by tablename获取指定架构下的所有表SELECT ... 阅读全文