Using SQL-Server? Check the SQL Server Books Online for the ALTER TABLE
Syntax.
CREATE TABLE foo (
bar varchar(25)
);
ALTER TABLE foo
ALTER COLUMN bar
varchar(100);
Works for me!
-S
___________________________________________
Sean Brown <[EMAIL PROTECTED]>
http://www.westcar.com/
"Either way you get your dog back"
-Anonymous
___________________________________________
-----Original Message-----
From: Jason Egan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 10, 2000 1:39 PM
To: Cf-Talk
Subject: modify tables
I�m learning the alter tables sql command� I can create and drop, but when I
try to use:
Alter Table tbl_jobs modify jobemail varchar(35)
After creating the field with:
Alter Table tbl_jobs add jobemail varchar(25)
I get an error in the alter table command??
Ideas?
je
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
