dumb sql question (fwd)

dumb sql question (fwd)

Post by Naomi Walk » Thu, 11 Mar 1993 08:33:03



 > Is there a way to querry a database (whose name you do know) and get a
 > list of its tables ? I'd also like to get a list of columns for a table
 > (once I know its name)
 >
 > I'm trying to build an ad-hoc querry tool.
 >
 Yup.  Try:

        select tabname, tabid from systables;

 to get a list of the table names.

 To get columns for that table:

         select * from syscolumns where tabid=xxxx;

 xxxx is the tabid of the table of interest.

 --

                                          Phoenix, Arizona
   To get the full value of joy,
   you must have someone to divide it with.   ---Mark Twain

 
 
 

1. dumb dumb dumb

Since this is an inner join:

[Table] +++++  [Table]

I thought an outer join must be like this:

++[Table]         [Table]++
+                                    +
++++++++++++++++++

Since that makes no sense, I've been confused for years.
Why use the terms "inner" and "outer" if they can't be taken literally?

2. Pls Help... SQL Server Login failure

3. OpenROAD: A few questions. (fwd)Re: Open (fwd)

4. env vars: DB_LOCALE

5. SQL Server for Access 2000 (here's another dumb blonde question from me)

6. sql And ADSI

7. Dumb ASP/SQL Question by newbie

8. multiple tnsnames.ora files

9. A real dumb question about sql client.

10. Dumb SQL/ASP newbie question

11. Dumb question about cascading deletes in SQL Server 2000

12. Dumb SQL question

13. Dumb question about SQL