5 Apr
2007
5 Apr
'07
9:35 p.m.
1. How do you change a column's NULLable setting? I tried "alter table tmp_t alter column x set not null;" with no success. 2. How do you rename a table, short of "create table new_name like old_name;"? I tried "ALTER TABLE tmp_t RENAME TO tmp_t_new;" with no success.