list

List all tables in a sql server database using a query Part 65

0:00
Toggle fullscreen Fullscreen button

Sharing buttons:

this part sixty five of secret silver

tutorial in this video we discuss

writing a transact sequel query to list

all the tables in a sequel server

database this is a very common sequel

server interview question within sequel

server management studio we can use

object Explorer to list all the tables

that belong to a specific database for

example if we have to find the tables

that belong to the sample database we

can simply expand the database with an

object Explorer and then expand the

tables folder and then you can find the

list of tables that belong to the sample

database on the other hand if I have to

write a query to achieve the same then

we can make use of three system views we

can either use this objects sister or

tables or information underscore schemas

or tables views the sis objects view is