Zydecode Studio

Archive for July, 2006

CF database schema dump

Thursday, July 20th, 2006

needed to get a dump of an old database schema via Cold Fusion:

SELECT *
FROM Information_Schema.Tables
ORDER BY Table_Name

SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM Information_Schema.Columns
WHERE Table_Name = ‘#Table_Name#’
ORDER BY Ordinal_Position

[...]