Published on: 02 Feb, 2014

How to list all tables in SQL Server?

Tumblr Digg Google Plus

You may wonder how to display all the tables that are predefined or created by user in SQL Server Database.

Below is the sql script:

select * from sysobjects where xtype='u'

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.