Re: [SQL] SET DEFAULT

2002-11-13 Thread Achilleus Mantzios
On Wed, 13 Nov 2002, Archibald Zimonyi wrote: > > Hi everyone, > > I have a problem with adding a column to an existing table. I want to add > a column named modified which is of datatype TIMESTAMP and has a DEFAULT > CURRENT_TIMESTAMP as it's initial value. I cannot do this with ALTER > TABLE, it

[SQL] SET DEFAULT

2002-11-13 Thread Archibald Zimonyi
Hi everyone, I have a problem with adding a column to an existing table. I want to add a column named modified which is of datatype TIMESTAMP and has a DEFAULT CURRENT_TIMESTAMP as it's initial value. I cannot do this with ALTER TABLE, it tells me to user ALTER TABLE SET DEFAULT instead but I can