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 @@error in sql?

1021

What is the guest user account in sql server? What login is it mapped to it? : sql server security

1006

Where are sql server usernames and passwords stored in the sql server?

1042

What is normalization and its types?

963

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

923

What is data source in connection string?

850

What are the difference between primary key and unique key? : sql server database administration

892

How to edit table in sql server 2017?

880

How many types of keys are there?

964

How to find which stored procedure is currently running in sql server?

925

What is index fragmentation in ms sql server?

1023

Explain DBCC?

908

What is ms sql server service broker?

932

why would you use sql agent? : Sql server database administration

1115

What does <> symbol mean?

918