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
How to resolve the orphan use problem? : sql server security
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
What are the various editions of sql server 2017 that are available in the market?
When would you use the stored procedures or functions?
How efficient you are in oracle and SQL server?
Do you think BCNF is better than 2NF & 3NF? Why?
Do you know the cursor types?
What are different types of replication in sql server?
What is difference between global temporary tables and local temporary tables?
How do I create a trace in sql server?
Why I am getting this error when dropping a database in ms sql server?
How to insert stored procedure result into temporary table?
what is checksum in sql server.........???
Determine when an index is appropriate?
How to view the error log for any specific instance? : sql server database administration