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 difference between primary key and unique key? : sql server database administration

987

What is normalization? What number of normalization shapes are there?

1151

Can you force a query to use a specific index?

985

What are the disadvantages of using the stored procedures?

1183

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

992

Explain about Joins?

1033

What is exporting and importing utility?

1135

how to control the amount of free space in your index pages? : Sql server database administration

1083

What is a full text index?

964

Define indexes?

1093

Should you normalize audio?

1001

How can we delete a table in sql server?

1017

What are indexes in sql?

1344

what's new in sql server 2016?

1000

Can two tables share a primary key?

1071