Skip to main content

index-tablespace

Why?​

You might enforce that indexes are placed in a specific tablespace, distinct from the tablespace of tables.

This rule will fail if there is no tablespace given when creating an index, or when configured with a pattern, will fail if the given tablespace does not match the pattern.

Options​

  • pattern - (regex, as string) optional regular expression that the tablespace of any created index must adhere to

Example Usage​

To simply ensure that a name is always given:

{
  "rules": {
    "index-tablespace": true
  }
}

To ensure that a pattern is matched:

{
  "rules": {
    "index-tablespace": {
      "pattern": "^IDX_[A-Z_]+$"
    }
  }
}