+1 vote
80 views
in Database Management Systems by

1 Answer

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

Unique constraints ensure that the data contained in a column or a group of columns is unique with respect to all the rows in the table. The syntax is  

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

when written as a column constraint, and

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

when written as a table constraint.

Related questions

+1 vote
1 answer 79 views
+1 vote
1 answer 89 views
+1 vote
1 answer 196 views
+1 vote
1 answer 186 views
+1 vote
1 answer 615 views
0 votes
1 answer 29 views
0 votes
1 answer 77 views
0 votes
1 answer 78 views
+1 vote
1 answer 97 views
+1 vote
1 answer 121 views
+1 vote
1 answer 164 views
+1 vote
1 answer 203 views
+1 vote
1 answer 95 views
+2 votes
1 answer 420 views
+2 votes
1 answer 511 views
+2 votes
1 answer 768 views
+2 votes
1 answer 385 views
+1 vote
1 answer 506 views
+2 votes
1 answer 486 views
+1 vote
1 answer 592 views
+1 vote
1 answer 332 views
+1 vote
0 answers 17 views
+1 vote
1 answer 36 views
+1 vote
1 answer 37 views
+1 vote
1 answer 37 views
+1 vote
1 answer 49 views
0 votes
1 answer 85 views
+1 vote
1 answer 43 views
0 votes
1 answer 65 views
asked Oct 25 in Database Management Systems by (user.guest)
0 votes
1 answer 84 views
asked Sep 23 in Database Management Systems by (user.guest)
+1 vote
1 answer 72 views
+1 vote
1 answer 74 views
asked Sep 23 in Database Management Systems by anonymous
+1 vote
1 answer 157 views
+1 vote
1 answer 196 views
+1 vote
1 answer 395 views
+1 vote
1 answer 68 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...