重命名表结构数据库

oracle

1、复制表结构
create table sms_send_record_bak_202220615 as select * from sms_send_record where 1=2;

2、插入短信数据
insert into sms_send_record_bak_202220615 select * from sms_send_record where send_date > to_date('2022-05-1 00:00:00','yyyy-mm-dd hh24:mi:ss')

3、查询数据短信
select * from sms_send_record_bak_202220615;

4、重命名
//RENAME sms_send_record TO sms_send_record_bak_202220614;
//RENAME sms_send_record_bak_202220615 TO sms_send_record;
//RENAME sms_send_record_bak_202220614 TO sms_send_record_bak_202220615;

sqlserver:

1、创建表结构
select * into t_b_prescription_drugstore_bak_20220615
from t_b_prescription_drugstore where 1= 2;

2、复制数据
insert into t_b_prescription_drugstore_bak_20220615(id,prescription_id,drugstore_id,create_datetime)
select id,prescription_id,drugstore_id,create_datetime from t_b_prescription_drugstore
where create_datetime > '2022-06-01'

3、设置主键命令

4、设置主键自增起始值命令

5、修复数据

insert into t_b_prescription_drugstore(prescription_id,drugstore_id,create_datetime)
select prescription_id,drugstore_id,create_datetime from t_b_prescription_drugstore_bak_20220616
where prescription_id in ('处方ID');

--select:t_b_prescription_drugstore_bak_20220616
--insert:t_b_prescription_drugstore

6、sqlserver 重命名语句操作

exec sp_rename 't_b_prescription_drugstore', 't_b_prescription_drugstore_bak_20220616';
exec sp_rename 't_b_prescription_drugstore_bak_20220615', 't_b_prescription_drugstore';

重命名表名

exec sp_rename 'oldName', 'newName';

重命名字段名

exec sp_rename 'tableName.[oldName]', 'newName', 'column';