Goal Make sure that you do not drop INFORMATION_SCHEMA schema. In this case most of the design checking queries will not work. This schema automatically exists in all databases.
Type Problem detection Each row in the result could represent a flaw in the design
Reliability High Few or no false-positive results
License MIT (opens in new tab)
Data Source INFORMATION_SCHEMA+system catalog
SQL Query 
SELECT 'INFORMATION_SCHEMA has been deleted' AS comment
WHERE NOT EXISTS (SELECT *
FROM pg_namespace AS n INNER JOIN pg_authid AS a ON n.nspowner=a.oid
WHERE (n.nspname='information_schema' AND a.rolname='postgres'));

DROP TABLE IF EXISTS x;

Fixing Suggestion

Make the dump of the database, create a new database, and restore your database objects and data based on the dump in the new database.

SQL statement to clean up temporary or helper database objects created for or by this query.

DROP TABLE IF EXISTS x;

Collections

This query belongs to the following collections:

Find problems automatically

Queries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not .

NameDescription
Find problems automaticallyQueries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not .

Categories

This query is classified under the following categories:

Schemas

Queries of this category provide information about databse schemas

NameDescription
SchemasQueries of this category provide information about databse schemas