Unfortunately, this is different for each database vendor. There is no standard
interface for querying the names of the tables and columns in the database.
Most of them have 'system tables' which store all of the "Meta-data" about the
database schema. You will have to select that information out of those system tables.
At 11:34 AM 11/15/00 +0100, Dominic J. Doucet-Lorang wrote:
>Nick,
>
>I was referring to the tables and columns in a database.
>
>Dominic
>
>At 10:08 15.11.00 +0000, you wrote:
>> > I was wondering if anyone new of a easy way in CF to get a list
>> > of all variables in a database and output that list.
>>
>>Dominic,
>>
>>What do you mean by "all variables in a database"? Are you
>>referring to Client variables? Or do you mean what tables and
>>columns exist?
>>
>>Nick
>>
>>
>>**********************************************************************
>>Information in this email is confidential and may be privileged.
>>It is intended for the addressee only. If you have received it in error,
>>please notify the sender immediately and delete it from your system.
>>You should not otherwise copy it, retransmit it or use or disclose its
>>contents to anyone.
>>Thank you for your co-operation.
>>**********************************************************************
>>------------------------------------------------------------------------------------------------
>>Archives: http://www.mail-archive.com/[email protected]/
>>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
>with 'unsubscribe' in the body to [EMAIL PROTECTED]
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938
To put this contact information into your Palm device, click here:
http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
