Pages

Men

rh

7/12/2018

Query : How to find out particular column is available or not in entire Database using Sql Query

SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS

 WHERE COLUMN_NAME LIKE  '%first name%'    (first name is column name. it will search in whole database  and give the result)

 order by COLUMN_NAME 

1 comment :

  1. Tejuteju10/31/2018 5:57 am

    Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…!!..
    Azure Online Training Hyderabad

    ReplyDelete

Subscribe to: Post Comments ( Atom )