Database predicate constraints on structured query language statements

摘要

A method of enforcing database predicate constraints on database accesses is provided. The method comprises receiving a database query, parsing the query based on constraints defined in system tables, and examining the query for the existence of a where clause. The method also comprises examining the where clause to determine compliance with the constraints defined in the system tables and executing the query only when the query contains a where clause and the where clause complies with the constraints defined in the system tables. The method also comprises rejecting the query when the query one of does not contain a where clause and does contain a where clause and the where clause does not comply with the constraints defined in the system tables.