SELECT T2.[NAME] FROM SYSCOLUMNS T1 INNER SYSOBJECTS T2 ON T1.ID=T2.ID AND T1.[NAME]='字段名'
select a.name dbname, b.name colname from sysobjects a , syscolumns b where a.id=b.id and a.xtype = 'u' order by a.name , b.colid
select a.name dbname, b.name colname from sysobjects a , syscolumns b where a.id=b.id and a.xtype = 'u' order by a.name , b.colid--select a.name dbname, b.name colname from sysobjects a , syscolumns b where a.id=b.id and a.xtype = 'u' and b.name = '你需要的字段' order by a.name , b.colid
select name as colname,object_name(id) as tbname from syscolumns where name='colname'
select object_name(id) from syscolumns where name='字段名'
SELECT T2.[NAME] FROM SYSCOLUMNS T1 INNER JOIN SYSOBJECTS T2 ON T1.ID=T2.ID AND T1.[NAME]='fgid'
select a.name,b.name from syscolumns a,sysobjects b where a.id=b.id and b.xtype='u' and a.name='colname'
create table test(fild int,zd int,code int) insert test select 1,500,1 union all select 2,30,1 union all select 1,700,2 union all select 2,70,2 go--drop table test select name as colname,object_name(id) as tbname from syscolumns where name='zd'colname tbname -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- zd test(所影响的行数为 1 行)
use databasename select object_name(id) from syscolumns where name='字段名'
select name as colname,object_name(id) as tbname from syscolumns where name='字段名'
还有就是用 sp_depends '字段名'
select name as colname,object_name(id) as tbname from syscolumns where name='字段名'
select name as colname,object_name(id) as tbname from syscolumns where name='字段名''
查哪些表包含指定的字段select object_name(c.id) as tableName from sysobjects as o inner join syscolumns as c on o.id=c.id and o.xtype='U' where c.name='kq_num字段'
SELECT T2.[NAME] FROM SYSCOLUMNS T1 INNER JION SYSOBJECTS T2 ON T1.ID=T2.ID AND T1.[NAME]='字段名'
INNER SYSOBJECTS T2 ON T1.ID=T2.ID AND T1.[NAME]='字段名'
from syscolumns where name='colname'
select object_name(id) from syscolumns where name='字段名'
INNER JOIN SYSOBJECTS T2 ON T1.ID=T2.ID AND T1.[NAME]='fgid'
from syscolumns a,sysobjects b
where a.id=b.id and b.xtype='u' and a.name='colname'
create table test(fild int,zd int,code int)
insert test
select 1,500,1 union all
select 2,30,1 union all
select 1,700,2 union all
select 2,70,2
go--drop table test
select name as colname,object_name(id) as tbname
from syscolumns where name='zd'colname tbname
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
zd test(所影响的行数为 1 行)
select object_name(id) from syscolumns where name='字段名'
from syscolumns where name='字段名'
sp_depends '字段名'
from syscolumns where name='字段名'
select name as colname,object_name(id) as tbname
from syscolumns where name='字段名''
查哪些表包含指定的字段select object_name(c.id) as tableName
from sysobjects as o inner join syscolumns as c
on o.id=c.id and o.xtype='U'
where c.name='kq_num字段'
SELECT T2.[NAME] FROM SYSCOLUMNS T1
INNER JION SYSOBJECTS T2 ON T1.ID=T2.ID AND T1.[NAME]='字段名'