sql select column name like from multiple tables

Solutions on MaxInterview for sql select column name like from multiple tables by the best coders in the world

Search
showing results for - "sql select column name like from multiple tables"
Alan
16 Jan 2018
1USE AdventureWorks 
2GO 
3SELECT t.name AS table_name,
4SCHEMA_NAME(schema_id) AS schema_name,
5c.name AS column_name
6FROM sys.tables AS t
7INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
8WHERE c.name LIKE '%EmployeeID%'
9ORDER BY schema_name, table_name; 
10
source
similar questions
get all tables with column name sqlselect tables with name like mysqlmysql select tables with name likesql server search column name in all tablessql select two columnssql 7c select data from multiple tablessql server check for value in multiple columnsselect 2a from table where name likeselect all same column value in sqlsql view where tables have same column name combine resultsget all tables using likeselect query in sql for multiple valuesselect 2 rows in sqlsql select rows with simlar namessql get all columns from one table but one from another inner joinmultiple like in sqlsql query use select name inside where clausesql select all from one table and one column from anotherselect all columns except one sqlsql select rows with different values in one columnhow to select from two tables in sqlselecting multiple columns in sqlselect a field from another table sql as fieldsearch all tables all columns for a specific value in mssql serversql server find columns list in tablesoracle sql like multiple valuessql query multiple tables
queries leading to this page
select one column from all tables sql without table nameselect where column in 2 tables sqlfind column in a table sql serverget coloums in table with one coloumsql select 2a from multiple tableshow to use like in sql for multiple columnsqlite select from multiple tablessql select multiple columnssql multiple selects from same tablesql select columns from multiple tablessql select column name like from multiple tables