Tuesday, August 7, 2012

How do you find tables with particular column by name in Sybase?

SELECT Object_name(id)
FROM syscolumns
WHERE name = '<Coulmn Name>'


or

SELECT sysobjects.name
FROM sysobjects, syscolumns
WHERE sysobjects.id = syscolumns.id

AND syscolumns.name = '<Column Name>'

No comments :