Finding Table by Column Name in SQL Server
Hello everyone,
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.
95 Views
