public static void CopyTableStructure(SqlTableReference sourceTable, SqlTableReference targetTable)
{
var sisTable = InformationSchemaMetadataExplorer.GetInformationSchemaTableDefinition(sourceTable);
var createTableScript = SISToSqlDmlCreateStatementGenerator.GenerateCreateTableScript(sisTable);
targetTable.SqlConnectionProvider.Execute(createTableScript);
}
public void TestSampleCreateTableScript()
{
var tableDefinition = InformationSchemaTableDefinitionFromJson.SampleTable();
var script = SISToSqlDmlCreateStatementGenerator.GenerateCreateTableScript(tableDefinition);
Console.WriteLine(script);
}
public void CreateIfTests()
{
var tableDef = InformationSchemaTableDefinitionFromJson.SampleTable();
var createAnywayScript =
SISToSqlDmlCreateStatementGenerator.GenerateCreateTableScript(
tableDef, CreateIfExistsModification.CreateAnyway);
var dropAndRecreateScript =
SISToSqlDmlCreateStatementGenerator.GenerateCreateTableScript(
tableDef, CreateIfExistsModification.DropAndRecreate);
var createOnlyIfNotExistsScript =
SISToSqlDmlCreateStatementGenerator.GenerateCreateTableScript(
tableDef, CreateIfExistsModification.CreateIfNotExists);
Console.WriteLine(createAnywayScript);
Console.WriteLine(dropAndRecreateScript);
Console.WriteLine(createOnlyIfNotExistsScript);
}