Unknown table

[hameja]

Dear All

I want to select some piece of data from unknown table. I know from oracle or informix there dba_tables and user_tables where you can formulate a query.

2. Which table holds other tables.

John

 

[dbomrrsm]

select * from information_schema.tables

[blue]DBomrrsm[/blue]

 

[dbomrrsm]

or:

select * from sysobjects
where xtype = 'u'

[blue]DBomrrsm[/blue]

 

[donutman]

Last time there were two xtypes that you told me to remember...of course I forgot the 2nd one. Was it for something else?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[dbomrrsm]

if you do a

select distinct(xtype)
from sysobjects

there are 10 types
X
P
PK
TF
IF
FN
U
D
V
S

all system object types
PK - primary key
U - user object
V view
not sure about all of them

[blue]DBomrrsm[/blue]