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
Printable View
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
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
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