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

What is sql server 2000 work load governor?

1081


What is Dependency Injection and provide example?

1135


How to change parameter value inside the report?

167


Explain what are the basic functions for master, msdb, model, tempdb databases?

993


What is an identity?

1026


Explain about Normalization?

1071


How use inner join in sql server?

1144


What are commonly used mssql functions in php?

1094


Where is localdb stored?

956


What is the difference between for auto and for nested?

1021


What is usually the first word in a sql query?

1146


How connect excel to sql server?

1009


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1131


What is an example of a foreign key?

989


What are the five major components of a dbms?

946