public void Test_MS_CreateClusteredIndex()
{
Initialize(_msContext);
_commands.ExecuteNonQuery(string.Format("create table {0} (id int, id2 int, id3 int)", _testTable));
IIndexDefinition index = _msContext.PowerPlant.CreateIndexDefinition("i1_" + _testTable, _testTable, "", true, 0, true);
index.Columns = new List <IIndexColumn> {
IndexColumnFactory.CreateInstance("id")
};
_dbSchema.CreateIndex(index);
CheckIndexIsClustered();
}
private void ClusteredIndexOnAgrtid(ITableDefinition tableDefinition)
{
if (CreateClusteredIndex && _dbContext.DbType == DbTypeName.SqlServer)
{
var index = _dbContext.PowerPlant.CreateIndexDefinition(
"aic_" + tableDefinition.Name,
tableDefinition.Name,
tableDefinition.Location,
true, /* is unique */
0, /* id */
true /* is clustered */);
index.Columns = new List <IIndexColumn> {
IndexColumnFactory.CreateInstance("agrtid")
};
_dbSchema.CreateIndex(index);
}
}
