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 the difference between mysql and sql server?

1087


What does it mean to be in union?

979


tell me the disaster recovery plan

2559


How to access the deleted record of an event?

1091


Can you edit the .rdl code associated with a linked report?

168


What is temporary stored procedure?

987


Define full outer join in sql server joins?

1047


What are dml triggers and types of dml triggers?

1028


Find first and last day of current month in sql server

1080


How retrieve field names from the table in SQL through JAVA code?

1955


In which sql server version report builder introduced?

150


Which is the best place or learning center for MS SQL?????In Bangladesh?????

2111


What is sql server schema compare? How we can compare two database schemas?

1078


How can we call UDF(User Define Function) using C# code in ASP.net ?

6946


What is history table in sql server?

1028