Re: Altering column syntax help/and repare

2006-01-18 Thread Martijn Tonies
> I think I really misunderstood the directions for alter table, an I'm > not sure how to fix this. I was trying to allow certain columns to be > null in an existing table. > I used the following syntax: > ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL; > Now 'describe users;' shows ex

Altering column syntax help/and repare

2006-01-18 Thread John Stile
I think I really misunderstood the directions for alter table, an I'm not sure how to fix this. I was trying to allow certain columns to be null in an existing table. I used the following syntax: ALTER TABLE users ALTER COLUMN title SET DEFAULT NULL; Now 'describe users;' shows extra columns wit