" 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
|