我用的是SQL2008,
有个一个部门表T_Deptment,
有两个字段: Deptment_ID int , Deptment varchar(20)
我怎样才能查找到,所有引用Deptment_ID的表啊?
或者将所有包含Deptment_ID的表列出来啊?
有个一个部门表T_Deptment,
有两个字段: Deptment_ID int , Deptment varchar(20)
我怎样才能查找到,所有引用Deptment_ID的表啊?
或者将所有包含Deptment_ID的表列出来啊?
解决方案 »
- c语言链接数据库编程
- |zyciis| 麻烦帮我发析一下,我手写的SQL和NHibernate生成的SQL的性能相差有多远
- 两个sql server数据库如何同时更新或者定时更新?
- sql安装在两台服务器,共用1个ip(对外),怎样向任意一台服务器读写数据?
- 一个触发器内三种INSERT,UPDATE,DELETE状态都包括,如何判断此触发是处于那种状态触发的?
- 请大家帮我写一个如下的存储过程,谢谢!
- 丢失LDF,有MDF,还能恢复数据库吗?
- 急-急-急---SQL查询结果不对---请高手指教---有分--在线等待
- sysbase download
- 急用!如何查找2个或2个以上的连续号码的记录
- 简单的SQL
- 谁来帮帮我
and id in (select id from syscolumns where name='Deptment_ID')
column_name
from information_schema.columns
where column_name='Deptment_ID'
name
from
sysobjects
where
type='u'
and
id in (select id from syscolumns where name='Deptment_ID')
select name from sysobjects where xtype = 'u'
查所有包含某一列名的所有表。
select obj.name from sysobjects obj,syscolumns col where col.id = obj.id and col.name='userid'
select OBJECT_NAME(parent_object_id)
from sys.foreign_key_columns
where referenced_object_id=OBJECT_ID('T_Deptment') and
referenced_column_id=(select column_id from sys.columns
where [object_id]=OBJECT_ID('T_Deptment') and name='Deptment_ID');
-- 查询引用 @tabname 表上 @colname 列的表和列
declare @tabname sysname, @colname sysname;select OBJECT_NAME(parent_object_id) table_name,
COL_NAME(OBJECT_ID(@tabname),parent_column_id) column_name
from sys.foreign_key_columns
where referenced_object_id=OBJECT_ID(@tabname) and
referenced_column_id=COLUMNPROPERTY(OBJECT_ID(@tabname),@colname,'columnid');