Answers for "select all the tables in a database for column name"

SQL
5

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;
Posted by: Guest on July-20-2020
0

mysql select all table that have field names

SELECT DISTINCT
	TABLE_NAME
FROM
	INFORMATION_SCHEMA.COLUMNS
WHERE
	COLUMN_NAME IN('column1', 'column2')
	AND TABLE_SCHEMA = 'schema_name';
Posted by: Guest on November-12-2020

Code answers related to "select all the tables in a database for column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language