How to find all tables containing column with specified name in MS SQL ?

Question

How to find all tables containing column with specified name in MS SQL ?

Is it possible to query for table names which contain columns being



LIKE '%myName%'

?

sql-server mysql

4 years ago by rahul07

2 Answers

Login / Signup to Answer the Question.

Login Signup

**Sonali7** · Answer 1 · 2021-05-01T10:53:07

The below code can be implemented to find all tables containing column with specified name in MS SQL :

SELECT      COLUMN_NAME AS 'ColumnName'

            ,TABLE_NAME AS  'TableName'

FROM        INFORMATION_SCHEMA.COLUMNS

WHERE       COLUMN_NAME LIKE '%MyName%'

ORDER BY    TableName

            ,ColumnName;

**Shahlar1vxp** · Answer 2 · 2021-05-04T15:39:21

If you wish to get all tables in MS SQL, the code is as follows-

SELECT TABLE_NAME 

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME like '%'

and TABLE_SCHEMA = 'tresbu_lk'

And if you wish to get all tables with specific column names in MS SQL, then go for the following code-

SELECT DISTINCT TABLE_NAME, COLUMN_NAME  

FROM INFORMATION_SCHEMA.COLUMNS  

WHERE column_name LIKE '%'  

AND TABLE_SCHEMA='tresbu_lk'

You may use this query code to replace the desired column name by your own column name-
SELECT TABLE_NAME FROM information_schema.columns WHERE column_name = 'desired_column_name';

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

How to find all tables containing column with specified name in MS SQL ?

2 Answers

Login / Signup to Answer the Question.