Best Tutorials website


Primary Keys and Unique Columns in Oracle and SQL-Server

Primary Keys and Unique Columns in Oracle and SQL-Server

The SQL-92 standard requires that all values in a primary key be unique and that the column not allow null values. Both Oracle and Microsoft SQL Server enforce uniqueness by automatically creating unique indexes whenever a PRIMARY KEY or UNIQUE constraint is defined. Additionally, primary key columns are automatically defined as NOT NULL. Only one primary key is allowed per table.




Views: 1502 | Rating star 3 | by Jason




View this tutorial
Broken link Report broken link?