Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1119


How self join is different from outer join?

1123


What is merge statement?

1084


What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1027


What is snapshot parameter in ssrs?

150


How global temporary tables are represented and its scope?

977


What are the source of constraints?

933


What is apply operator in sql?

1014


What are the joins in sql server? : sql server database administration

1014


What is pessimistic concurrency?

977


What is recompile sql server?

1043


How do I completely remove sql server instance?

1106


How to find the login name linked to a given user name?

1011


Tell me what is de-normalization and what are some of the examples of it?

1054


What is the difference between row_number and dense_rank?

882