I have written a .cfm to output a listing of columns with Name, Format, Size, NULL, KEY,
etc.
One thing I need to include is whether the Primary Key is AUTO_INCREMENT
That element does not appear to be in the same SCHEMA table.
Where is it ? and How can I use it with this Query ... ?
<CFQuery datasource="bs3578" name="pColumns" >
SELECT COLUMN_NAME AS pCname,
DATA_TYPE AS pDtype,
IS_NULLABLE AS pISnull,
CHARACTER_MAXIMUM_LENGTH AS pMAXlen,
COLUMN_DEFAULT AS pCdefault,
COLUMN_TYPE AS pCtype,
COLUMN_KEY AS pCkey,
NUMERIC_SCALE AS pNscale,
NUMERIC_PRECISION AS pNprec
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = "Products" AND TABLE_SCHEMA = "bs3578";
</cfquery>
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12962 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.