rename table;

1、oracle or mysql rename
alter table test rename to test1;

select count(*) from test1;

RENAME TABLE test1 TO test2;
2、mysql rename database;
alter database test modify name =test2;

3、sybase
exec sp_renamedb 'test','test1' ;

相关日志