---- Excuse the heresy for
answering an SS question on this list.
When I first read that statement I was wondering
why you would be asking a question about the Nazi SS on an Oracle List
..... then it dawned on me that you were talking about Microsoft SQL
Server ... at which point it did not mater ... Nazi SS ... Microsoft
... prety much the same thing.
-----Original Message-----
From: Grant Allen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 9:20 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: doubtExcuse 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, useselect o.name
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.CiaoFuzzy(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
