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)
-
Module Tester Sub Main () Dim firstNumber, secondNumber As String Dim number1, number2, sumOfNumbers As Intege...
-
Option Explicit Off Module Module1 Sub Main () EmployeeName = "Buddy Jamsa" EmployeePhoneNumber = ...
-
Module Module1 Sub Main () Dim AnInt As Integer = 5 Dim ALong As Long = 7 ALong = AnInt 'ca...
No comments:
Post a Comment