Categories
28°C, New York
Home SQL SQL_DBA

SQL_DBA

Using sys.column and sys.table view

Find all Tables that contain a specific Column name in SQL Server

When managing a database in SQL Server, it’s often necessary to find out which tables include a specific column name. This task is essential for database administrators and developers, especially when updating database structures, migrating data safely, or getting a better understanding of how information is organized.

There are two ways to find all tables that contain a specific column name in SQL Server:

  • Using sys.column and sys.table view
  • Using INFORMATION_SCHEMA.COLUMNS View

Similar Reads

SQL_DBA

...

Using sys.column and sys.table view

Using sys.columns and sys.tables views, users can find all tables that contain a specific column name....

Using INFORMATION_SCHEMA.COLUMNS View

Using INFORMATION_SCHEMA.COLUMNS view, you can find all tables that contain a specific column name in the SQL database....

Tags:
#SQL-Server #SQL

Using sys.column and sys.table view