Column Search | SansSQL

Tuesday, December 25, 2007

Column Search

/*This script searches the specified column name from the database and displays the table names in which it is present.*/

select sysobjects.name, * from syscolumns, sysobjects where syscolumns.name like '%EmpID%'and sysobjects.id = syscolumns.id and (sysobjects.xtype='U' or sysobjects.xtype='S')

3 comments:

Brave Technologies said...

Thank you for this valuable information. Get your business to the next level in simple steps. We provides lowest price of erp Software for our clients erp software in Chennai

Huongkvb said...

Mua vé máy bay tại Aivivu, tham khảo

vé máy bay đi Mỹ

lịch bay từ mỹ về việt nam

các đường bay từ canada về việt nam

có vé máy bay từ nhật về việt nam không

Giá vé máy bay Hàn Việt Vietjet

Vé máy bay từ Đài Loan về VN

vé máy bay cho chuyên gia nước ngoài

melianalim said...

you will need support or suggestions, write me privately.
I interested in your implementation/use case.
the best kera4d
Togel2win

Post a Comment

Ads