string sql_Svr = $"SELECT COL.COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS COL Where COL.TABLE_NAME='{表名}'";//SQLServer查询表中字段
string sql_Svr_copytable = $"IF NOT EXISTS (select * from dbo.sysobjects where xtype='U' and Name = '{表名}')" +
"BEGIN"+
$"select* into {表名} from {旧表名} where 1=2" + //SQLServer查询表格是否存在,不存在则创建(这里根据现有的表格复制)
"END";
string sql_copytable = $"create table {新表名} like {旧表名};"; //MySql创建相同字段的表格
string sql_getcode = $"SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = '{数据库名}' AND table_name ='{表名}'";//MySql查询表中字段
string sql_creattable = $"CREATE TABLE IF NOT EXISTS{新表名}(like{旧表名})";//MySql查询表格是否存在,不存在则创建(这里根据现有的表格复制)
整理一些重复建表时用的SQL语句
最新推荐文章于 2023-12-06 20:30:00 发布