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

Explain for xml explicit mode?

912


What is resultset concur_updatable?

969


what are constraints? : Sql server database administration

982


What is the difference between DataRow.Delete() and DataRow.Remove()?

1166


Explain log shipping and mention its advantages.

988


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3816


Can two tables have the same primary key?

1133


According to you what goes into making the best database administrator? : sql server database administration

937


Does partitioning improve performance sql server?

897


What are scalar functions?

947


Explain isolation levels that sql server supports?

986


What do you mean by subquery?

1021


State a few properties of relational databases?

1060


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181


Are resultset updatable?

895