Posts Finding a column in database
Post
Cancel

Finding a column in database

Here is the query that will help you to find a particular column in the database. This query will return you the table name in which that column is found.

select so.name, sc.name
from syscolumns sc
inner join sysobjects so on sc.id = so.id
where sc.name = 'SystemColumn'
This post is licensed under CC BY 4.0 by the author.