[RBASE-L] - Re: Command that show all table's relations ??? -Razzak's Reply

[A. Razzak Memon]

At 08:23 AM 11/28/2003 -0500, Mario B�dard wrote:

Someone knows a command that can show me all relations �tablish into my
database.
It's new database for me. it has � 20 tables, but i appraciate to find the
design on the table. Sur with Objet manager I can see table and take a look
fot eache one, but I want to find de realtion between the tables...


Mario,

01. Start R:BASE 6.5++

02. CONNECT dbname

03. At the R> Prompt:

    LIST (to display the list of Tables/Views)

    LIST TABLES (to display the list of Tables only)

    LIST VIEWS (to display the list of Views only)

    LIST TABLE TableName
    (to display the list of columns as well as any PRIMARY KEY REFERENCED
     or FOREIGN KEY REFERENCES tablename)
    LIST COLUMN
    (to display the alphabetical list of all columns and associated tables)
    LIST RULES
    (to display data validation RULES)
    LIST CONSTRAINTS
    (to list data constraint type as well as NOT NULL constraints)
    LIST FORMS
    (to display the list of Forms)
    LIST REPORTS
    (to display the list of Reports)
    LIST LABELS
    (to display the list of Labels)
    LIST FORMS FOR TableName
    (to display the list of forms for a given table)
    LIST REPORTS FOR TableName
    (to display the list of reports for a given table)
    LIST LABELS FOR TableName
    (to display the list of labels for a given table)
Hope that helps!

Enjoy and make sure to have fun!

Very Best R:egards,

Razzak.