At 09:29 AM 3/30/2009, Mike Casey wrote:
I was wondering if someone could help me out with some RBASE
SQL commands.
I need to know the SQL to;
1. List all of the tables within the database
2. List all of the columns within a particular table
3. List a particular column type and length
In addition to using the "LIST" command in R:BASE, you may
also use R:Documenter http://www.rdocumenter.com to document
"everything" related to any given R:BASE database.
Here's an PDF output when documenting Running R:BASE Your Way!
Part 14 (RRBYWW14):
01. Complete Documentation of RRBYW14
http://www.rdocumenter.com/RRBYW14_Complete_Documentation.pdf
02. Tables Only
http://www.rdocumenter.com/RRBYW14_TABLES.pdf
03. Views Only
http://www.rdocumenter.com/RRBYW14_VIEWS.pdf
04. SYS_Tables Only
http://www.rdocumenter.com/RRBYW14_SYS_TABLES.pdf
05. Primary Keys Only
http://www.rdocumenter.com/RRBYW14_PRIMARY_KEYS.pdf
06. Foreign Keys Only
http://www.rdocumenter.com/RRBYW14_FOREIGN_KEYS.pdf
07. Indexes Only
http://www.rdocumenter.com/RRBYW14_INDEXES.pdf
08. Forms Only
http://www.rdocumenter.com/RRBYW14_FORMS.pdf
09. Labels Only
http://www.rdocumenter.com/RRBYW14_LABELS.pdf
10. Reports Only
http://www.rdocumenter.com/RRBYW14_REPORTS.pdf
Have fun reviewing the amazing PDF output by R:BASE tools!
R:BASE Solutions: http://www.rbasesolutions.com
Very Best R:egards,
Razzak.
