In this lesson, we will get a list of all the tables in our database and list it on the page.
This will return the following.
Name, ID, xtype, uid, info, status, base_schema_ver, etc...

Open SQL Server Management Studio.
Right-Click on the database.
Choose [New Query]
Paste the below code and click [Execute]

SELECT * FROM SYSOBJECTS WHERE xtype = 'U'; GO