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

How to delete duplicate rows?

941

What is tabulation?

902

What does the on update no action do?

972

how would you troubleshoot blocking? : Sql server database administration

950

How to define and use table alias names in ms sql server?

1060

How is SQL Azure different than SQL server?

223

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

1121

What is the meaning of resultset type_scroll_insensitive?

919

How do I create a stored procedure in sql server?

971

Can we install sql server 2016 on windows 7?

1082

What are the differences between triggers and stored procedures?

999

What are transactions in sql?

993

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

925

Explain what are various ways to enhance the ssrs report?

1000

What are two difference between sql azure and azure tables?

159