Is there a way to specify a column in which table it is used with SQL Query?

Question

Is there any way for a column in which table is it using SQL Query?

Answer 1

yes, Assuming this is a db SQL server, you can check the query below -

select [name], object_name(id) from sys.columns where [name] like '%columnname%'

object_name (id) will give you the table name for the specified column name.

Answer 2

You can try something like this using Sql Server 2005+

SELECT OBJECT_NAME(c.OBJECT_ID) TableName, c.name ColumnName
FROM sys.columns c
WHERE c.name = '<column name>'

Answer 3

Try

SELECT OBJECT_NAME(id) FROM syscolumns WHERE [name] = 'mycolumn'

Answer 4

syscolumns ( , ), , . .

Answer 5

If you are trying to figure out from which table a particular column arose in a query, the best option is to alias all the columns at the time of writing the queries. I would not accept any code in a code review that does not do this, because it is a pain to understand later.