Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn't allow NULLs, but unique key allows one NULL only.
Subscribe to:
Post Comments (Atom)
-
Changing the values of some properties is fairly easy. We'll now change the Text properties of our labels, and the Text properties of o...
-
At the moment, our form looks a little bland. Time to liven it up with a splash of colour. Changing the colour of the Form means we have t...
-
There's a lot happening on the start page. But basically, this is where you can start a new project, or open an existing one. The first...
No comments:
Post a Comment