Finding Table by Column Name in SQL Server
In this article, I will try to give information about finding a table from the column name in SQL Server.
In SQL Server, in some cases, you may want to find a table by column name.
You can easily do this using the code below.
SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'CategoryID';
When you run the above code, you will see a result similar to the one below.
As you can see, we have found the table name from the column name.
Good luck to everyone in business and life.