Excuse
the heresy for answering an SS question on this list.
Jai,
you can fight with the INFORMATION_SCHEMA views, or use sp_help to see all the
objects for all users (not just tables). If you looking for just
tables, and only for a given user, use
select
o.name
from sysobjects o, sysusers u where
o.uid = u.uid
and o.xtype = 'U'
and u.name = 'yourusernamehere'
from sysobjects o, sysusers u where
o.uid = u.uid
and o.xtype = 'U'
and u.name = 'yourusernamehere'
(obviously change the yourusernamehere bit to the
username desired). You might want to try the usenet
comp.databases.ms-sqlserver group for more info.
Ciao
Fuzzy
(yech
... I'm sorry, the MS brainwashing must be stronger than I thought ... I have
this irresistible urge to clap my hands and sway back and forth with a moronic
grin on my face after thinking of SQL Server. Can anyone suggest a
therapist? :-) :-) :-) ).
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, January 02, 2003 14:04
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
