Q3017 How can I create tables with SQL in ColdFusion?

CREATE TABLE Email(EMAIL TEXT, ID INTEGER CONSTRAINT ID PRIMARY KEY);

CREATE TABLE tablename (columnName  datatype [primary key] [NOT] NULL [,])

CREATE [unique/clustered] INDEX indexname ON tablename(columnName(s))

integer (integer identity), char(x), datetime, money, real, double, smalldatetime, smallmoney, and some others.