Answered Questions

  • What is the need of primary key as opposed to using not null and unique ?

    we can create a column with' not null+unique' with out using primary key

    PRADEEP

    • Oct 17th, 2012

    Primary key: set of columns is uniquely identified a rows of a table. It does not allow both nulls and duplicate values. If we use null values it will allow duplicate values but it does not allow n...

    Radha

    • Jul 14th, 2011

    We can create NOTNULL and UNIQUE constraints on single column. Which indirectly means a Primary Key. But only a Primary Key column can be used as Foreign key column. Primary key provides a default...