/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 vote183 views1 answer
Mysql replication change database name
SQL
10 votes195 views2 answers
Sql pagination offset
SQL
1 vote177 views1 answer
Clear screen command in psql
SQL
1 vote167 views1 answer
Reutrn string after character sql
SQL
0 vote171 views1 answer
Psql initialization
SQL
0 vote175 views1 answer
Recursive query herarchical data sql server
SQL
0 vote165 views1 answer
Mysql select last 15 minutes
SQL
0 vote172 views1 answer
Check duplicate values plsql
SQL
0 vote199 views1 answer
Synapse sql table set pk
SQL
1 vote189 views1 answer
Postgres see sequence current state
SQL