/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

4 votes107 views1 answer
What are the data types in sql
SQL
3 votes107 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote105 views1 answer
Psql select * from table
SQL
5 votes103 views2 answers
Sql number columns
SQL
0 vote109 views1 answer
How to select only id where is not in column mysql
SQL
3 votes109 views4 answers
Mysql decimal
SQL
0 vote112 views1 answer
Original Query
SQL
0 vote117 views1 answer
Mssql check if date is greater than today
SQL
0 vote220 views1 answer
Sqlite display data in separated columns
SQL
0 vote130 views1 answer
Sql server information_schema temp tables
SQL