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
Here's how:
CONNECT dbname IDENTIFIED BY owner password
At the R> Prompt:
SET LINES 0
LIST TABLES -- to list all tables alphabetically
LIST VIEWS -- to list all views alphabetically
2. List all of the columns within a particular table
LIST tablename
3. List a particular column type and length
LIST COLUMN colname
LIST COLUMNS -- to list all columns
That's all there is to it!
Very Best R:egards,
Razzak.
