/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 vote324 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
-1 vote388 views4 answers
Full outer join in sql
SQL
0 vote336 views1 answer
Sql_inner_join
SQL
0 vote296 views1 answer
Sql select rows with simlar names
SQL
3 votes346 views2 answers
Postgresql remove not null constraint
SQL
0 vote322 views1 answer
Sub blocks in sql
SQL
0 vote319 views1 answer
Sql developer format sql
SQL
0 vote378 views1 answer
Postgres foreign key multiple columns
SQL
0 vote346 views1 answer
Django how to get query result count
SQL
0 vote335 views2 answers
SQL BULK INSERT
SQL