Find column name in database sql server?

 /************************************/

 /* find column name in database sql server?

/*************************************/


/********* Search Tables:***********/

SELECT      c.name  AS 'ColumnName'

            ,t.name AS 'TableName'

FROM        sys.columns c

JOIN        sys.tables  t   ON c.object_id = t.object_id

WHERE       c.name LIKE '%MyName%'

ORDER BY   TableName,ColumnName;



/**** Search Tables and Views: *******/

SELECT      COLUMN_NAME AS 'ColumnName'

            ,TABLE_NAME AS  'TableName'

FROM        INFORMATION_SCHEMA.COLUMNS

WHERE       COLUMN_NAME LIKE '%MyName%'

ORDER BY    TableName

            ,ColumnName;


ANIL SINGH

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..

My Tech Blog - https://www.code-sample.com/
My Books - Book 1 and Book 2

Find column name in database sql server? Find column name in database sql server? Reviewed by Anil Singh on 5:26 AM Rating: (5)
www.code-sample.com/. Powered by Blogger.
^