Re: [SQL] Restricting a VIEW.

--- Terry Yapt <[EMAIL PROTECTED]> wrote: > Hello all, > > I have a doubt. In the next example, I have a table > with two columns: > - DATE > - MONEY > > And a VIEW which SUM's the money GROUPing by > 'month/year' (I cut off the day)... > > Ok.. I would like to be able to SELECT * FROM VIEW..

Re: [SQL] adding column with not null constraint

On Fri, 2002-10-18 at 22:12, Vivek Khera wrote: > ALTER TABLE msg_owner ADD COLUMN user_optional_fields VARCHAR(255); > ALTER TABLE msg_owner ALTER user_optional_fields SET DEFAULT ''; > UPDATE msg_owner SET user_optional_fields = ''; > > Now my problem is I cannot find any syntax for ALTER TABLE