0
what will be the mssql query for listing all tables from a database?
need to show all the tables from one particular database
8 Réponses
+ 4
select * from database_name.INFORMATION_SCHEMA.TABLES
+ 3
Show tables from database name;
0
show tables;
0
show tables;
0
show tables
0
show tables;
0
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
0
SELECT * FROM SYS.TABLES
will show you all the tables in a database