ALTER TABLE tablename ADD (fieldname datatype() [other keywords]);
Exactly what you can do w/ the ALTER TABLE ADD|DROP|MODIFY statement is
highly dbms specific, but generally all support adding a single field per
statement. For the exact restrictions your dbms places on a this statement
(especial
alter table add
For example:
alter table names add firstname varchar (20) NULL
HTH,
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - the World's most configurable mail server
Get your free copy of iMS POST
At 01:12 PM 1/30/01 -0600, you wrote:
>hey yall, how do i make a co9lumn in an existing table and specify dataype
>and length and stuff
alter table add
you can use that as your sql statement with cfquery or in an interface to
the db.
Now announcing my newly updated website
http://www.blivi
what database?
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 2:13 PM
To: CF-Talk
Subject: CREATE COLUMN
hey yall, how do i make a co9lumn in an existing t
4 matches
Mail list logo
