List all the tables from the database

Posted Date: 07 Aug 2008 Resource Type: Code Snippets Category: SQL

Posted By: lavanya Member Level: Gold
Rating:

Points: 1

This sample code is a query that will list all the tables in a database. This information is obtained using the sys.objects table. The type 'U' implies user-defined tables



select name from sys.objects where type = 'U'

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Table list . List of all tables in a database . All tables in a database .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Getting the Number of SQL Instances running in Network
	Previous Resource: List all the stored procedure in Database
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

masks masks masks