sql如何获得表对应的架构名称
123 select d.name as table_name, a.name as column_name from syscolumns a inner join sysobjects d on a.id = d.id and d.xtype = 'U' where a.name = '表名'
select schema_name([schema_id]) 'schema' from sys.objects where type='U' and name='[表名]'