what will be the mssql query for listing all tables from a database?

Question

need to show all the tables from one particular database

Answer 1

select * from database_name.INFORMATION_SCHEMA.TABLES

Answer 2

Show tables from database name;

Answer 3

show tables;

Answer 4

show tables;

Answer 5

show tables

Answer 6

show tables;

Answer 7

first write
1. use database name ;
then write
2. show tables;

the first one will enable the particular database for you and the second query will show the list of the all tables in that database

Answer 8

SELECT * FROM SYS.TABLES
will show you all the tables in a database