SQL_DBA
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