how to list tabes based on column name in sybase?

来源:互联网 发布:淘宝首页改版 编辑:程序博客网 时间:2024/05/20 11:27

select distinct object_name(id)
from syscolumns
where name = 'my_column_name'
order by object_name(id)


select distinct so.name
from syscolumns sc
  , sysobjects so
where sc.id = so.id
and   sc.name = 'my_column_name'
order by so.name

0 0
原创粉丝点击