Re: SQL table operations question

Article View: bit.listserv.sqlinfo

Article #231

Back to bit.listserv.sqlinfo Previous Next

#231

From: Roland Zumkeller
Date: Mon, 07 Aug 2000 00:00

17 lines
939 bytes

Dear Fabien,
Actually this can depend very much on your DBMS. There are certain
ANSI-standards for it, though, and you must see if your DBMS complies
with them.

Try these:

SELECT * FROM INFORMATION_SCHEMA.TABLES

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

There are more of these pseudo-tables, but the first one gives you their
names.

I hope this helped.

Roland

Technical Details

Message-ID: <398DECC1.6FF716C2@web.de>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <39869B88.CA7F0305@sbs.be>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,7a40e3744c30110f
X-Google-Attributes: gid11355a,public
From: Roland Zumkeller <Roland.Zumkeller@web.de>
Subject: Re: SQL table operations question
Date: 2000/08/07
Message-ID: <398DECC1.6FF716C2@web.de>
X-Deja-AN: 655215352
Content-Transfer-Encoding: 7bit
References: <39869B88.CA7F0305@sbs.be>
X-Accept-Language: de
Content-Type: text/plain; charset=us-ascii
X-Trace: fu-berlin.de 965602528 7074752 62.54.4.184 (16 [43476])
Mime-Version: 1.0
Newsgroups: bit.listserv.sqlinfo

Reply to Parent Message