SHOW TABLES?

[Andrew Sinning]

ah, found it:

-- dbConn in the dbObject instance
count = GetBaseObjectCount(dbConn)
repeat with n = 1 to count
  put GetBaseObjectName(dbConn,n)
end repeat


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Frank Schima
Sent: Thursday, February 12, 2004 3:34 PM
To: Valentina Developers
Subject: Re: SHOW TABLES?


Hi guys,


On Feb 12, 2004, at 4:00 PM, Ruslan Zasukhin wrote:

> on 2/12/04 10:02 PM, Andrew Sinning at andrew at learningware.com wrote:
>
>> Is there a valid Valentina SQL statement such as SHOW TABLES?
>>
>> How does one get the tables?  I remember seeing this, but now I can't
>> find it in the docs.
>
>     SELECT * FROM table_name

Ruslan, I think he wants a SQL command to list all the table names in
the database. MySQL, at least, has this SQL command. I'm not sure if it
is in the standard.

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina