Query to return all user table names

[John Caro]

Hi all,
I am newbie VB to SQL. I want to write a SQL statement that will return the user table names
of a database without having to open it in enterprise manager or an explorer.
Thank you for help on this basic question.
John Caro

[Markus]

SELECT name from sysobjects
WHERE type = 'U'


------------
John Caro at 3/15/01 11:32:37 PM


Hi all,
I am newbie VB to SQL. I want to write a SQL statement that will return the user table names
of a database without having to open it in enterprise manager or an explorer.
Thank you for help on this basic question.
John Caro

[John Caro]

Thank You

------------
Markus at 3/16/01 2:49:05 AM

SELECT name from sysobjects
WHERE type = 'U'


------------
John Caro at 3/15/01 11:32:37 PM


Hi all,
I am newbie VB to SQL. I want to write a SQL statement that will return the user table names
of a database without having to open it in enterprise manager or an explorer.
Thank you for help on this basic question.
John Caro