Zydecode Studio

CF database schema dump

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



Comments are closed.