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 times
Join today, and add this to your favorites.
Coding Source - Share on MySpace Coding Source - Share With Facebook Coding Source - Share on Twitter Coding Source - Share on Reddit Coding Source - Share on Digg It Coding Source - Share on Stumble Upon It Coding Source - Share on Delicious
Share With Friends (Updated 6-8-2010)

Supported Files
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]

SELECT
  *
FROM
  SYSOBJECTS
WHERE
  xtype = 'U';
GO
Post to Facebook about: SQL Server Management Studio - List all tables in a database