今天发现了一条比较有用的sql语句,在这里记录下:
功能是查找整个数据库里某个字段在哪些表里;
select sysobjects.name
from syscolumns
inner join sysobjects on syscolumns.id=sysobjects.id
where syscolumns.name= '你想查找的字段'
-----扩展-----
查看所有表名:
select name from sysobjects where type='U'
查询表的所有字段名:
Select name from syscolumns Where ID=OBJECT_ID('表名')
select * from information_schema.tables
select * from information_schema.views
select * from information_schema.columns
Select OBJECT_NAME(id),name from syscolumns Where ID IN (select OBJECT_ID(name) from sysobjects where type='U')
AND name = 'UserName'
查询UserName字段在哪些表中出现