本人收集了一些资料,整理了一下:
1.在Oracle数据库中:
select owner, table_name
from all_tab_columns
where column_name in('a','b')
group by owner, table_name
having count(*)=2;
from all_tab_columns
where column_name in('a','b')
group by owner, table_name
having count(*)=2;
注释:a,b为列名;couture(*)为所列列的个数。
比如:
我要查询id属性所在的表:
select owner, table_name
from all_tab_columns
where column_name in('id')
group by owner, table_name
having count(*)=1;
from all_tab_columns
where column_name in('id')
group by owner, table_name
having count(*)=1;
2.在sql several中:
Select *
From sysobjects s
Where Exists(
Select *
From syscolumns
Where ID = s.ID and name = 'name1'
)
From sysobjects s
Where Exists(
Select *
From syscolumns
Where ID = s.ID and name = 'name1'
)
注释:name1是属性名