/SQL/Sql select column name like from multiple tables

Sql select column name like from multiple tables

USE AdventureWorks 
GO 
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%EmployeeID%'
ORDER BY schema_name, table_name;

Source: dba.stackexchange.com

Similar codes

0 vote178 views1 answer
Name '_mysql' is not defined
SQL
0 vote166 views4 answers
Best data type to represent money in mysql
SQL
0 vote225 views1 answer
Download sql file of countries names
SQL
0 vote166 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote162 views1 answer
Java sql connection
SQL
10 votes184 views4 answers
Else if mysql
SQL
0 vote235 views1 answer
Oracle convert int to date
SQL
0 vote190 views2 answers
Mysql missin expression near on
SQL
0 vote173 views1 answer
Sql server port 1434
SQL
0 vote230 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL