<cfquery name="addcolumn" datasource=""> alter table TABLENAME add NEWCOL varchar(255); </cfquery> TABLENAME: the name of your table NEWCOL: the name of your new column with column datatype