public static void CopyTableStructure(SqlTableReference sourceTable, SqlTableReference targetTable) { var sisTable = InformationSchemaMetadataExplorer.GetInformationSchemaTableDefinition(sourceTable); var createTableScript = SISToSqlDmlCreateStatementGenerator.GenerateCreateTableScript(sisTable); targetTable.SqlConnectionProvider.Execute(createTableScript); }
public void RetrieveHumanResourcesEmployeeTableAsJson() { var sqlTableReference = new SqlTableReference(SqlConnectionProviders.AdventureWorksDb, "HumanResources.Employee"); var informationSchemaTableDefinition = InformationSchemaMetadataExplorer.GetInformationSchemaTableDefinition(sqlTableReference); var tableDefinitionAsJson = JsonConvert.SerializeObject(informationSchemaTableDefinition); Console.WriteLine(tableDefinitionAsJson); }