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 many types of built in functions are there in sql server 2012?

913

What is the xml datatype?

1037

Can sql servers linked to other servers like oracle?

938

how to do partition in sqlserver

2456

Explain the difference between HTTP and HTTPS in database?

1022

Do you know what is a with(nolock)?

1047

Using the customer, and order table in northwind database, please write a query to produce xml?

1061

can you instantiate a com object by using t-sql? : Sql server database administration

989

What are date and time data types in ms sql server?

1080

What is the use of keyword with encryption.

1021

How to create a store procedure with encryption?

992

Can a function call a stored procedure in sql server?

944

What is the server name in sql server?

993

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1059

What are the differences between local and global temporary tables?

1069