Li, Chunshen (Don)
>
>That is why you should use the INFORMATION_SCHEMA. Just try
>
><cfquery datasource="" name="qColumns">
>SELECT *
>FROM information_schema.columns
>WHERE table_name = 'myTable'
></cfquery>
><cfdump var="qColumns">
>
>You should also check out the rest of the INFORMATION_SCHEMA, it
>allows you to see (almost) everything of the schema (in a
>compliant database), from the datatypes and defaults of columns
>to the permissions and triggers defined on a table.
>
>Jochem
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
