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
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