How to find a column name in large list of tables in a database? скачать в хорошем качестве

How to find a column name in large list of tables in a database?

Have you been in a situation where you are new to company and you are handed a new database which you haven't looked at before and you need to update a column X in that database, but you do not know which table to find that column in. You are new so you feel hesitant to ask someone in company, so here is a query that comes in handy and you can sue to get the columnname and the table name in a huge database. Query: 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 '%vendor%'   ORDER BY    TableName         ,ColumnName; Please Like , Share and Subscribe to channel Data Savvy With Aks!!!