0

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

need to show all the tables from one particular database

9th Aug 2016, 4:00 PM
Sainath
Sainath - avatar
8 Réponses
+ 4
select * from database_name.INFORMATION_SCHEMA.TABLES
10th Aug 2016, 5:49 AM
Sainath
Sainath - avatar
+ 3
Show tables from database name;
9th Aug 2016, 7:57 PM
Piyush Giri
Piyush Giri - avatar
0
show tables;
10th Aug 2016, 4:33 AM
JOSE RODRIGO VELOSA GIL
JOSE RODRIGO VELOSA GIL - avatar
0
show tables;
11th Aug 2016, 11:48 AM
Jay Narayan
Jay Narayan - avatar
0
show tables
13th Aug 2016, 3:54 PM
Ricardo Frontado
Ricardo Frontado - avatar
0
show tables;
13th Aug 2016, 10:15 PM
JOSE RODRIGO VELOSA GIL
JOSE RODRIGO VELOSA GIL - avatar
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
11th Sep 2016, 6:07 PM
Shreyansh Dwivedi
Shreyansh Dwivedi - avatar
0
SELECT * FROM SYS.TABLES will show you all the tables in a database
16th Mar 2017, 3:06 AM
Mohammed Adnan
Mohammed Adnan - avatar