ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}
sql语法
转载于:https://www.cnblogs.com/jianshao810/archive/2010/05/28/1746247.html
ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}
sql语法
转载于:https://www.cnblogs.com/jianshao810/archive/2010/05/28/1746247.html