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

How to turn on the mssql api module in php?

759


What stored by the msdb? : sql server database administration

749


How to configure and test odbc dsn settings?

799


What are commonly used mssql functions in php?

713


What is a raid and what are different types of raid configurations?

843






What is the main difference between ‘between’ and ‘in’ condition operators?

796


How to delete duplicate records based on single column from a table?

780


how you can get the list of largest tables in a database? : Sql server administration

725


What is a user-defined function in the sql server and what is its advantage?

819


How to connect of datebase with sql express.?

815


Which is faster statement or preparedstatement?

699


What are partitioned views and distributed partitioned views?

798


What is stored in the mssqlsystemresource database? : sql server database administration

777


Explain what is row_number function?

756


How to select some specific rows from a table in ms sql server?

759