Home Articles FAQs XREF Games Software Instant Books BBS About FOLDOC RFCs Feedback Sitemap
irt.Org
#

Q3017 How can I create tables with SQL in ColdFusion?

You are here: irt.org | FAQ | ColdFusion | Q3017 [ previous next ]

Use the following formats:

MS Access

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

SQL Server

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.

©2018 Martin Webb