Nope that is not it for SQL 2000 I get error with mine Incorrect Syntax near open_close
on 5/17/02 5:20 PM, Ben Johansen at [EMAIL PROTECTED] wrote: > 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
