Deveel.Data.DeleteCurrentTests.CreateTable C# (CSharp) Method

        private void CreateTable(IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");
            query.Access().CreateTable(table => table
                .Named(tableName)
                .WithColumn(column => column
                    .Named("id")
                    .HavingType(PrimitiveTypes.Integer())
                    .WithDefault(SqlExpression.FunctionCall("UNIQUEKEY", new SqlExpression[] {
                        SqlExpression.Constant(tableName.FullName)
                    })))
                .WithColumn("a", PrimitiveTypes.Integer())
                .WithColumn("b", PrimitiveTypes.String()));

            query.Access().AddPrimaryKey(tableName, "id", "PK_TEST_TABLE");
        }