Filter Queries
Found 1053 queries.
- All the queries about database objects contain a subcondition to exclude from the result information about the system catalog.
- Although the statements use SQL constructs (common table expressions; NOT in subqueries) that could cause performance problems in case of large datasets it shouldn't be a problem in case of relatively small amount of data, which is in the system catalog of a database.
- Statistics about the catalog content and project home in GitHub that has additional information.
#61. Perhaps a relationship should be irreflexive
system catalog base tables onlyEnforce all the constraints. A binary relation is called irreflexive, if it does not relate any element to itself.
#62. All foreign key constraints
system catalog base tables onlyEnforce referential integrity in database. Find all referential integrity (foreign key) constraints.
#63. Enumerated types with zero or one value
INFORMATION_SCHEMA+system catalog base tablesFidn enumerated types with zero or one value. Type is a named finite set of values. The empty set is a set. A set with one value is a set. Thus, types with zero or one value are legal. In practical terms each type, usually, should contain at least two values.
#64. Name does not contain any vowels (aggregate view)
INFORMATION_SCHEMA+system catalog base tablesFind aggregate information about the names of database objects that do not contain any vowels.
#65. Base table columns where TOASTing is possible
system catalog base tables onlyFind all base table columns in case of which the system can use TOAST technique.
#66. Base tables with exactly one key
system catalog base tables onlyFind all base tables that have exactly one PRIMARY KEY or UNIQUE constraint. Find and enforce all the keys. Are you sure there are not more keys in the table?
#67. All CHECK constraints of domains that are not associated with any table
INFORMATION_SCHEMA onlyFind all CHECK constraints (except NOT NULL) of domains that are not associated with any column.
#68. Table check constraints with regular expressions
INFORMATION_SCHEMA onlyFind all CHECK constraints (except NOT NULL) that are associated with a base table or a foreign table column and use a regular expression. It is useful to enforce as many constraints at database level as possible. In this way one improves data quality as well as gives extra information to the database users (including the DBMS engines, development environments, and applications).
#69. All table CHECK constraints that cover at leat one column
INFORMATION_SCHEMA onlyFind all CHECK constraints (except NOT NULL) that are associated with a base table or a foreign table column. It is useful to enforce as many constraints at database level as possible. In this way one improves data quality as well as gives extra information to the database users (including the DBMS engines, development environments, and applications).
#70. Consistency of CHECK constraint name and content
INFORMATION_SCHEMA onlyFind all CHECK constraints that name contains a digit. Make sure that the name and the Boolean expression are consistent.
#71. All column dynamic DEFAULT values values that do not invoke a sequence
INFORMATION_SCHEMA onlyFind all columns that have a dynamic default value, i.e., the value is returned by a function but the function is not for invoking a sequence.
#72. All column static DEFAULT values
INFORMATION_SCHEMA onlyFind all columns that have a static default value, i.e., the value is not returned by a function.
#73. Comments of columns
system catalog base tables onlyFind all comments of columns of tables.
#74. All covering indexes
INFORMATION_SCHEMA+system catalog base tablesFind all covering indexes, which include data from additional columns in leaf blocks.
#75. Deferrable constraints
system catalog base tables onlyFind all deferrable constraints.
#77. All enumerated types
INFORMATION_SCHEMA+system catalog base tablesFind all enumerated types.
#78. All exclude constraints
system catalog base tables onlyFind all exclude constraints.
#79. All foreign tables
INFORMATION_SCHEMA onlyFind all foreign tables.
#80. All table functions
INFORMATION_SCHEMA+system catalog base tablesFind all functions that return a set of rows.
| # | Name | Goal (sorted ascending) | Type | Data source | Last update | License | Actions |
|---|---|---|---|---|---|---|---|
| 61 | Perhaps a relationship should be irreflexive | Enforce all the constraints. A binary relation is called irreflexive, if it does not relate any element to itself. | Problem detection | system catalog base tables only | MIT (opens in new tab) | View (opens in new tab) | |
| 62 | All foreign key constraints | Enforce referential integrity in database. Find all referential integrity (foreign key) constraints. | General | system catalog base tables only | MIT (opens in new tab) | View (opens in new tab) | |
| 63 | Enumerated types with zero or one value | Fidn enumerated types with zero or one value. Type is a named finite set of values. The empty set is a set. A set with one value is a set. Thus, types with zero or one value are legal. In practical terms each type, usually, should contain at least two values. | Problem detection | INFORMATION_SCHEMA+system catalog base tables | MIT (opens in new tab) | View (opens in new tab) | |
| 64 | Name does not contain any vowels (aggregate view) | Find aggregate information about the names of database objects that do not contain any vowels. | Sofware measure | INFORMATION_SCHEMA+system catalog base tables | MIT (opens in new tab) | View (opens in new tab) | |
| 65 | Base table columns where TOASTing is possible | Find all base table columns in case of which the system can use TOAST technique. | General | system catalog base tables only | MIT (opens in new tab) | View (opens in new tab) | |
| 66 | Base tables with exactly one key | Find all base tables that have exactly one PRIMARY KEY or UNIQUE constraint. Find and enforce all the keys. Are you sure there are not more keys in the table? | General | system catalog base tables only | MIT (opens in new tab) | View (opens in new tab) | |
| 67 | All CHECK constraints of domains that are not associated with any table | Find all CHECK constraints (except NOT NULL) of domains that are not associated with any column. | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 68 | Table check constraints with regular expressions | Find all CHECK constraints (except NOT NULL) that are associated with a base table or a foreign table column and use a regular expression. It is useful to enforce as many constraints at database level as possible. In this way one improves data quality as well as gives extra information to the database users (including the DBMS engines, development environments, and applications). | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 69 | All table CHECK constraints that cover at leat one column | Find all CHECK constraints (except NOT NULL) that are associated with a base table or a foreign table column. It is useful to enforce as many constraints at database level as possible. In this way one improves data quality as well as gives extra information to the database users (including the DBMS engines, development environments, and applications). | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 70 | Consistency of CHECK constraint name and content | Find all CHECK constraints that name contains a digit. Make sure that the name and the Boolean expression are consistent. | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 71 | All column dynamic DEFAULT values values that do not invoke a sequence | Find all columns that have a dynamic default value, i.e., the value is returned by a function but the function is not for invoking a sequence. | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 72 | All column static DEFAULT values | Find all columns that have a static default value, i.e., the value is not returned by a function. | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 73 | Comments of columns | Find all comments of columns of tables. | General | system catalog base tables only | MIT (opens in new tab) | View (opens in new tab) | |
| 74 | All covering indexes | Find all covering indexes, which include data from additional columns in leaf blocks. | General | INFORMATION_SCHEMA+system catalog base tables | MIT (opens in new tab) | View (opens in new tab) | |
| 75 | Deferrable constraints | Find all deferrable constraints. | General | system catalog base tables only | MIT (opens in new tab) | View (opens in new tab) | |
| 76 | All domains | Find all domains. | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 77 | All enumerated types | Find all enumerated types. | General | INFORMATION_SCHEMA+system catalog base tables | MIT (opens in new tab) | View (opens in new tab) | |
| 78 | All exclude constraints | Find all exclude constraints. | General | system catalog base tables only | MIT (opens in new tab) | View (opens in new tab) | |
| 79 | All foreign tables | Find all foreign tables. | General | INFORMATION_SCHEMA only | MIT (opens in new tab) | View (opens in new tab) | |
| 80 | All table functions | Find all functions that return a set of rows. | General | INFORMATION_SCHEMA+system catalog base tables | MIT (opens in new tab) | View (opens in new tab) |