i




 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Finding Column in Tables
01-12-2012, 01:22 PM
Post: #1
Finding Column in Tables
Hi to All,

By using bellow query we can find in which table the column exists in

database

Code:
SELECT TABLE_SCHEMA,
       TABLE_NAME
FROM   INFORMATION_SCHEMA.COLUMNS
WHERE  COLUMN_NAME = 'Give Column Name'
Thank you,


Quote




User(s) browsing this thread: 1 Guest(s)