Re: DESCRIBE the entire database

I have never seen such a tool for Sybase. We built in-house tools with ksh and isql to describe/reverse engineer a database (into DDL) including data. If someone knows of a built in function or procedure, I'd love to know about it.

You could use sp_help, but you'll have to run it explicitly on each table. Also, if you are looking for DDL, it's not much good. Check out Ed Barlow's site at http://www.tiac.net/users/sqltech/ for some good sp's that do describing into DDL.

Mike

In article <6rs5fu$4ut$1_at_nnrp1.dejanews.com>,   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
>

-----== 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 CEST