select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE'

To get the list of User Defined table names..

Select * from sysobjects where type = 'u'

To get the list of system Defined table names..
Select * from sysobjects where type = 's'

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question