Tuesday, April 12, 2011

What's the difference between a primary key and a unique key?

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.
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Explain the different parts that constitute ASP.NET application.

Content, program logic and configuration file constitute an ASP.NET application. Content files Content files include static text, images ...

  • Explain the different parts that constitute ASP.NET application.
    Content, program logic and configuration file constitute an ASP.NET application. Content files Content files include static text, images ...
  • Explain the advantages of ASP.NET.
    Following are the advantages of ASP.NET. Web application exists in compiled form on the server so the execution speed is faster as compar...
  • Parse Integer
    public class  Test     public Shared Sub  Main          Try              Dim  num_items  As  Integer = Integer.Parse ( "123" ) ...