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>'
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 :
Post a Comment