You are here: irt.org | About | Feedback | 1180 [ previous next ]
Feedback on:
irt.org FAQ Knowledge Base Q3006
Sent by
Orlando Correa on May 04, 2000 at 11:48:28:
Worth:
Very worth reading
Comments:
I wrote the following CF for SQL Server to get all the tables using the system tables:
<CFQUERY NAME="getTables" DATASOURCE="#ds#" DBTYPE="ODBC">
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
<CFIF IsDefined("url.table_name")>
WHERE table_name='#url.table_name#'
<CFELSE>
ORDER BY table_schema, table_name, ordinal_position desc
</CFIF>
</CFQUERY>
Thanks for providing the MS Access version...
Other feedback on 'irt.org FAQ Knowledge Base Q3006' - show all