<cfquery name="q1" datasource="datasource">
SELECT * from INFORMATION_SCHEMA.tables
WHERE table_type = 'BASE TABLE'
ORDER BY table_name
</cfquery>
<cfquery name="q2" datasource="datasource">
SELECT * from INFORMATION_SCHEMA.columns
WHERE table_name = '#FORM.selectedTableName#'
ORDER BY column_name
</cfquery>
-----Original Message-----
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 21, 2006 9:11 PM
To: CF-Talk
Subject: Re: SOT: Any way to get table names and datatypes via a query?
That's awesome Hatton, thanks. I'll look in BOL to see if I can
figure a better way to find the datatypes, since only varchar and int
IDENTITY seem to be set in your script.
Thanks again,
Pete
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257687
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
