How do I list the available tables in a database I'm
querying?

Answer Posted / guest

You can get a list of tables in a database by calling the
INFORMATION_SCHEMA.Tables view like this:

SELECT * FROM information_schema.tables

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to resolve the orphan use problem? : sql server security

738


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2000


What are the various editions of sql server 2017 that are available in the market?

685


When would you use the stored procedures or functions?

774


How efficient you are in oracle and SQL server?

831


Do you think BCNF is better than 2NF & 3NF? Why?

1027


Do you know the cursor types?

888


What are different types of replication in sql server?

790


What is difference between global temporary tables and local temporary tables?

915


How do I create a trace in sql server?

729


Why I am getting this error when dropping a database in ms sql server?

809


How to insert stored procedure result into temporary table?

801


what is checksum in sql server.........???

1408


Determine when an index is appropriate?

791


How to view the error log for any specific instance? : sql server database administration

804