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 is Service Broker in sql server 2012?

816

How many database files are there in sql server 2000?what are they?

808

How will you optimize a stored procedure optimization?

723

Define primary key?

918

Do you know what is similarity and difference between truncate and delete in sql?

805

Can we insert data into a view?

871

How to set database to be single_user in ms sql server?

829

What is an example of a foreign key?

752

What is difference between temp table and cte?

782

What is nested transaction?

827

Explain nested join?

776

What is the difference between count () and rowcount ()?

774

In which files does sql server actually store data?

663

Explain log shipping?

818

What does it mean to be in union?

709