string sql_Rename_MainTable = string.Empty;  // 改表名(主表->历史表)的sql
string sql_Create_MainTable = string.Empty;  // 通过历史表的表结构创建主表的sql
switch (dbType)
{
    case DbType.MySql:
        sql_Rename_MainTable = "alter table {0} rename to {1}";  // alter table oldName rename to/as newName; 改表名(主表->历史表)的sql
        sql_Create_MainTable = "create table {0} like {1}";      // create table newName like oldName;通过历史表的表结构创建主表的sql
        break;
    case DbType.SqlServer:
        sql_Rename_MainTable = "EXEC sp_rename '{0}', '{1}'";    // exec sp_rename 'oldName', 'newName'; 改表名(主表->历史表)的sql
        sql_Create_MainTable = "select * into {0} from {1} where 1=2";  // select * into newName from oldName where 1=2; 通过历史表的表结构创建主表的sql
        break;
    default:
        // 略
        break;
}
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.

 

作者：꧁执笔小白꧂