Sunday, December 21, 2008

Find database table column

To find out a column you are not sure of where in your entire database, select database from the dropdown and run following query:

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = 'COLUMN_NAME'

No comments:

Post a Comment

Feel free to give constructive feedback or let me know if it was helpful.