Find tables without primary keys (PKs) in popular relational databases - Database Query Toolbox

Database Query Toolbox

Find tables without primary keys (PKs) in popular relational databases

Piotr Kononow
5th October, 2018

Queries below finds tables without primary keys (PKs) in popular relational databases:

SQL Server: Find tables without primary keys (PKs)

Azure SQL Database: Find tables without primary keys (PKs)

Oracle database: Find tables without primary keys (PKs)

Snowflake: Find tables without primary keys (PKs)

Amazon Redshift: Find tables without primary keys (PKs)

IBM Db2: Find tables without primary keys (PKs)

Teradata: Find tables without primary keys (PKs) in Teradata database

Vertica: Find tables without primary keys (PKs)

PostgreSQL: Find tables without primary keys (PKs)

MySQL: Find tables without primary keys (PKs)

MariaDB: Find tables without primary keys (PKs)

0

There are no comments. Click here to write the first comment.