You can get a list of tables in a database by calling the INFORMATION

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

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

What are the types of indexes?

768

What do you understand by SQL*Net?

782

How do I completely remove sql server instance?

776

What is index in an assignment?

695

Explain the phases a transaction has to undergo?

729

How many partitions a clustered index has by default in sql server 2012?

850

How to stop log file growing too big?

747

Which trace flags are enabled in sql server?

671

What is an execution plan?

741

Define union, union all, minus, intersect?

741

What is acid properties?

776

What is the use of nvl work?

719

What are the steps to take to improve performance of a poor performing query? : sql server database administration

785

What is triggers in ms sql server?

802

Explain the usage of floor function in sql server.

678