primary key

PostgreSQL Primary Key: CREATE and ALTER TABLE Statements

Referential Integrity is a must when it comes to proper relational database design. The consistent usage of primary keys can help you ensure the best practices of RDBMS are adhered to. In this article, we are going to focus on using PostgreSQL primary keys while creating a new table or editing the existing one. We will provide you with detailed instructions spiced up with the corresponding code examples and screenshots based on the PostgreSQL GUI tool for better visualization – dbForge Studio for PostgreSQL.

(more…)

Oracle CREATE TABLE Command in PL/SQL with 10 Examples

In this article, we are going to talk about the CREATE TABLE command. To be more precise, we will focus on how to create a table in Oracle with a primary and foreign key, as well as not null and date columns, take a close look at how to create a new table on a basis of the existing one, and more. Also, we will review the perks and benefits of using dbForge Studio for Oracle when working with tables.

(more…)

MySQL Primary Key: CREATE and ALTER TABLE Statements

Following the best practices of RDBMS involves the consistent usage of Primary Keys when designing databases to create and enforce Referential Integrity which is a major requirement for Data Quality and proper relational database design. In this tutorial, we provide background information on Primary Keys and their function as well as give code examples to illustrate the theory.

(more…)