i want table name basis on column name.

Answer Posted / saravanan p

Please find the below query in which, the tables are
selected depends the column name empNo.

select table_name from information_schema.columns where
column_name='empNo'

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a join in sql?

580


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

536


What are the components of sql server service broker?

506


What is scd (slowly changing dimension)? : sql server analysis services, ssas

587


What is Dependency Injection and provide example?

608






What are the difference between primary key and unique key? : sql server database administration

520


Mention the different types of triggers?

541


What is function of master database?

94


What is lookup override?

583


Explain what is raid and what are different types of raid levels?

526


When I delete any data from a table, does the sql server reduce the size of that table?

580


How do we know if any query is retrieving a large amount of data or very little data?

546


How to declare and use cursor variables?

579


Is null in sql server?

538


What is nolock?

549