Posted by Chandra on 08/04/05 12:59

Hi, you can write it as:

SELECT name [Table Name]
FROM sysobjects
WHERE xtype = 'U'

Please let me know if this helped

best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---------------------------------------

*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Re: Failed insert query
• Prev in forum: Re: Performance-String searching
• Thread view: Re: How to get table list from a db? Thanks!

[Reply to this message]