Query Template: /core/components/utilities/databaseconnector.cfc:138 Execution Time: 7.07 ms Record Count: 10 Cached: No Lazy: No SQL: SELECT COLUMN_NAME, DATA_TYPE, NUMERIC_SCALE, COLUMN_KEY, COLUMN_DEFAULT, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, COLUMN_TYPE, EXTRA, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'emailtemplate' AND TABLE_SCHEMA = DATABASE() ORDER BY ORDINAL_POSITION
	COLUMN_NAME	DATA_TYPE	NUMERIC_SCALE	COLUMN_KEY	COLUMN_DEFAULT	IS_NULLABLE	CHARACTER_MAXIMUM_LENGTH	COLUMN_TYPE	EXTRA	CHARACTER_SET_NAME
1	ID	int	0	PRI		NO		int	auto_increment
2	Name	varchar				YES	255	varchar(255)		latin1
3	EmailTemplateCategoryID	int	0		1	NO		int
4	Live	bit			b'1'	NO		bit(1)
5	Description	text				YES	65535	text		latin1
6	BID	int	0			YES		int
7	Content	text				YES	65535	text		latin1
8	Type	varchar				YES	10	varchar(10)		latin1
9	DesignID	int	0			YES		int
10	StyleSheet	varchar				YES	100	varchar(100)		latin1