Re: DESCRIBE the entire database

From: Ng K C Paul <paulkcng_at_news.netvigator.com>
Date: 1998/08/25
Message-ID: <6rt2o2$qcq$1@imsp009a.netvigator.com>#1/1

use sp_help <table_name>

sysdev_at_adpsystems.mb.ca wrote:
: Hello,
:
: When I studied databases in university,
: we used Sybase. There was a command in Sybase
: that would describe the entire database; show
: all the tables, their field structure, primary
: keys, foreign keys, and so on.
:
: Questions:
:
: What is this command in Sybase?
:
: Is there an equivilent command in Oracle?
: With Oracle's DESCRIBE,
: I can only describe tables and views.
:
: Regards,
:
: Rodger
:
:
: P.S. -
: My ISP is really bad with newsgroups.
: They post late, and delete early. Emails to:
: sysdev_at_adpsystems.mb.ca
: are greatly appreciated.
:
: -----== Posted via Deja News, The Leader in Internet Discussion ==-----
: http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Aug 25 1998 - 00:00:00 CDT