|
Previous Article SQL Server Management Studio - Change Recovery Model to Simple |
SQL Server Management Studio - List all tables in a database |
Next Article SQL Server Management Studio - How to alter the default value or binding of a table column |
Coding Article #: 1087 - Published On: February 13, 2021 @ 03:52:06 AM - Last Updated on: January 01, 1900
This article has been Favorited 0 timesJoin today, and add this to your favorites.
Share With Friends (Updated 6-8-2010)
Supported Files
No Files for this Article.
No Files for this Article.
No Screenshot Available
In this lesson, we are going to get a list of all the tables in our database and list it to 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]
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
Post to Facebook about: SQL Server Management Studio - List all tables in a database
