如何获得表对应的架构名称 如何获得表对应的架构名称 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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 s.[name]from sys.tables as tjoin sys.schemas as s on t.schema_id = s.schema_idwhere t.[name] = '表名' select schema_name([schema_id]) 'schema' from sys.objects where type='U' and name='[表名]' [Essence]The difference between datetime and char. 怎样按时间检索? 高分求救,怎么在SQL语句里访问ODBC里的数据 如何在SQL查询分析器中用create function这条命令,帮助中查询也未曾查到这条命令 远程连接数据库问题 急 求助 如何取字符字段的第几个字符,如取name的左边从2位起的2个字符? 关于SQL Server Profiler的问题? 一个很菜的问题 关于MSDE的安装问题 MSDE安装 远程连接只访问到默认数据库 SQL突然断电,导致异常错误
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 s.[name]
from sys.tables as t
join sys.schemas as s on t.schema_id = s.schema_id
where t.[name] = '表名'
select schema_name([schema_id]) 'schema'
from sys.objects
where type='U' and name='[表名]'