sqlserver
查找某数据库中所有的字段
select s.name,s.id,t.table_name from syscolumns s ,information_schema.tables t where s.id = object_id(t.table_name) and t.table_catalog = '数据库名'
and s.name = '字段名' order by table_name
sqlserver
查找某数据库中所有的字段
select s.name,s.id,t.table_name from syscolumns s ,information_schema.tables t where s.id = object_id(t.table_name) and t.table_catalog = '数据库名'
and s.name = '字段名' order by table_name