- Mysql中修改表名:
alter table table_name rename table_new_name;
Oracle:
Oracle(renametable_name to table_new_name)
2 修改表中列属性的长度:
ALTER TABLE users
MODIFY COLUMN sex CHAR(10)
alter table table_name rename table_new_name;
Oracle:
Oracle(renametable_name to table_new_name)
ALTER TABLE users
MODIFY COLUMN sex CHAR(10)