In
Query Analyzer select the database if interest and then run
EXEC
SP_HELP (really, this is not a joke) ;o)
It
will list system and user objects within that DB.
Dave
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L
Subject: doubt
Dear all,
we use "select * from tab" to list all objects in a particular user in oracle.
could you tell me the equivalent query in sql server ?
Regards
Jai
