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 the recovery model?

564


How to view the error log for any specific instance? : sql server database administration

583


Explain external key management in sql server 2008

504


What command would you use to create an index?

594


What is multi-statement table-value user-defined function?

539






What is cross join in sql server joins?

601


What is the meaning of sql server?

530


How to download and install microsoft sql server management studio express?

565


What is the difference between char, varchar and nvarchar?

579


What are the disadvantages of indexes?

537


How to enter unicode character string literals in ms sql server?

578


What are the common performance issues in sql server?

505


Can We Use Data-grids For Our Report In Ssrs?

147


What are the different authentication modes in sql server?

577


List the types of recovery model available in sql server?

507