Oracle-L: RE: doubt

From: Kevin Lange <kgel_at_ppoone.com>
Date: Thu, 02 Jan 2003 08:03:56 -0800
Message-ID: <F001.00525823.20030102080356@fatcity.com>

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-----
Sent: Thursday, January 02, 2003 9:20 AM To: Multiple recipients of list ORACLE-L

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'

(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-----
Sent: Thursday, January 02, 2003 14:04
To: Multiple recipients of list ORACLE-L

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kevin Lange
  INET: kgel_at_ppoone.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Jan 02 2003 - 10:03:56 CST