Sql query to find column name in database

This article is tagged with: Sql query to find column name in database and mysql

sql query to find column name in database

tablename search in sql

get all tables with column name sql

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;

get all tables with column name sql

Get table containing given field

get all columns from table sql

SELECT
TABLE_NAME
FROM
INFORMATION_SCHEMA.TABLES

This article is tagged with: Sql query to find column name in database and mysql