I think it is more on the lines of ALTER TABLE Courses MODIFY audience_ID numeric(9) NOT NULL DEFAULT 1
At least that is what it is in Sybase Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WiTangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Stein Sent: Friday, May 17, 2002 1:07 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Sql alter Syntax ALTER TABLE Courses ALTER COLUMN audience_ID numeric(9) NOT NULL DEFAULT 1 This gives me an error. I want to set the default to 1 -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 215-799-0192 610-256-2843 Fax 413-410-9682 FMP,Tango, EDI,SQL 7 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
