+1 vote
88 views
in Database Management Systems by

1 Answer

+1 vote
by
selected by (user.guest)
 
Best answer

Technically, a primary key constraint is simply a combination of a unique constraint and a not-null constraint. So, the following two table definitions accept the same data:  

CREATE TABLE products (product_no integer UNIQUE NOT NULL, name text, price numeric);  

CREATE TABLE products (product_no integer PRIMARY KEY,name text, price numeric);  

Primary keys can also constrain more than one column; the syntax is similar to unique constraints:  

CREATE TABLE example (a integer,b integer,c integer, PRIMARY KEY (a, c));

A primary key indicates that a column or group of columns can be used as a unique identifier for rows in the table. (This is a direct consequence of the definition of a primary key. Note that a unique constraint does not, in fact, provide a unique identifier because it does not exclude null values.) This is useful both for documentation purposes and forclient applications. For example, a GUI application that allows modifying row values probably needs to know the primary key of a table to be able to identify rows uniquely.

Related questions

+3 votes
1 answer 355 views
+1 vote
1 answer 78 views
+1 vote
1 answer 80 views
+1 vote
1 answer 194 views
+1 vote
1 answer 184 views
+1 vote
1 answer 124 views
0 votes
2 answers 171 views
asked Sep 19 in Computational Tools by (user.guest)
+1 vote
2 answers 174 views
+1 vote
1 answer 154 views
+1 vote
1 answer 613 views
0 votes
1 answer 36 views
+1 vote
1 answer 323 views
+1 vote
1 answer 140 views
+1 vote
1 answer 105 views
+1 vote
1 answer 96 views
+2 votes
1 answer 1.1k views
+3 votes
1 answer 3.1k views
+1 vote
1 answer 943 views
+2 votes
1 answer 1.8k views
+3 votes
1 answer 4.2k views
0 votes
1 answer 26 views
0 votes
1 answer 75 views
0 votes
1 answer 75 views
+1 vote
1 answer 94 views
+1 vote
1 answer 120 views
+1 vote
1 answer 163 views
+1 vote
1 answer 201 views
+1 vote
1 answer 94 views
+2 votes
1 answer 420 views
+2 votes
1 answer 510 views
+2 votes
1 answer 764 views
+2 votes
1 answer 383 views
+1 vote
1 answer 501 views
+2 votes
1 answer 486 views
+1 vote
1 answer 1.7k views
+1 vote
1 answer 1.7k views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...