sql 语句修改字段名,属性,默认值
9/19/2023 11:11:20 PM
修改字段名:
alter table tab_info rename column createname to thisname;
修改字段属性:
alter table tab_info alter column thisname varchar(200) not null;
修改默认值
alter table tabinfo add constraint df default('嘿嘿') for thisname;