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 ddl,dml and dcl commands?

1093


How can I create a report based on a query? : sql server management studio

997


What does nvl stand for?

933


What are Spatial data types in SQL Server 2008

999


What is sql profiler. What are the default templates with it? : sql server database administration

1009


What are the advantages of passing name-value pairs as parameters?

1149


What is bulkcopy in sql?

931


How do you identify a foreign key?

1007


How to insert and update data into a table with "insert" and "update" statements?

955


How does recursive cte works in sql server?

982


Explain what is sql server english query?

1027


What are the advantages of sql azure?

140


What languages bi uses to achieve the goal?

987


Explain important index characteristics?

1018


Does hive support indexing?

943