Create Table with CFQUERY
Create a table on the fly using CFQUERY and SQL
<cfquery name="
" datasource="">
	create table TABLENAME (
		[id]	int identity primary key,
		[name]	varchar(255) null,
		[created] datetime default getDate() not null
	);
</cfquery>

� TABLENAME =the name of your new table

� [id] = this is an example of how you could setup an "AutoNumber" type Identity field

� [name] = this is an example varchar field with a max length of 255 and allows nulls

� [created] = this is an example datetime field with a default value of the SQL servers date/time; using the GetDate() SQL function
 

cover
Buy Fusebox 5 & FLiP: Master-Class ColdFusion Applications
cover
Buy Fusebox 4 & FLiP: Master-Class ColdFusion Applications
cover
Buy ColdFusion Lists, Arrays, & Structures
cover
Buy ColdFusion XML Objects

Dedicated and Shared CF Hosting 2021