public void Simple()
{
var seqName = ObjectName.Parse("APP.seq2");
AdminQuery.CreateSequence(seqName);
var exists = AdminQuery.Access().ObjectExists(DbObjectType.Sequence, seqName);
Assert.IsTrue(exists);
}
public void WithValues()
{
var seqName = ObjectName.Parse("APP.seq2");
AdminQuery.CreateSequence(seqName,
SqlExpression.Constant(0),
SqlExpression.Constant(1),
SqlExpression.Constant(0),
SqlExpression.Constant(Int64.MaxValue),
SqlExpression.Constant(Int16.MaxValue));
var exists = AdminQuery.Access().ObjectExists(DbObjectType.Sequence, seqName);
Assert.IsTrue(exists);
}
public void Existing_Native()
{
var tableName = SystemSchema.TableInfoTableName;
Assert.Throws <StatementException>(() => AdminQuery.CreateSequence(tableName));
}
public void Existing_UserDefined()
{
var seqName = ObjectName.Parse("APP.seq1");
Assert.Throws <StatementException>(() => AdminQuery.CreateSequence(seqName));
}
