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
- how to list tabes based on column name in sybase?
- How to show/hide a control in the Column's DataItemTemplate based on the value of another control
- Linq to SQL how to do “where [column] in (list of values)”
- How To Split column In SQL
- HOW TO : Select column in Notepad++
- How to Get Interface Name List
- How to change the name in open with list / File association.
- Refreshing One Column based on the value of Another Column in ADFdi Table
- How to do reasoning/inference based on Jena
- Generic Netlink HOW-TO based on Jamal's original doc
- QT Creator based on VS2010 OpenGL-----How to config compiler
- How-to: write own Kafka Partitioner based on requirement
- Sybase- Invalid column name '2013-09-25'.
- How to Use Hive-based Registry IN WINCE.NET
- How to Use Hive-based Registry IN WINCE.NET
- How To Compile OpenCV based programs in Linux
- How To: Reset Identity column in SQL Server
- How to handle the space in column with awk?
- Oracle System密码忘记 密码修改、删除账号锁定lock
- Android移植---JNI中HelloWorld的C和C++实现
- SQL 存储过程入门(事务)
- eclipse中删除workspace
- shared memory driver(2)
- how to list tabes based on column name in sybase?
- Inside The c++ Object Model 读书笔记
- 我们需要根据设备的寄存器编写驱动么?
- iOS开发-retain/assign/strong/weak/copy/mutablecopy/autorelease区别
- css控制div显示/隐藏方法及2种方法比较原码
- 分享溜客2011年5月16日被检测过程
- Android语言切换
- 多进程通信(IPC)--共享内存
- strcspn和strspn函数