Identity Column - Code Samples

Code Samples

CREATE TABLE Contacts ( FirstName VARCHAR(30), LastName VARCHAR(30), Phone VARCHAR(16), ContactID INT IDENTITY(1, 1) )

or

CREATE TABLE Contacts ( FirstName VARCHAR(30), LastName VARCHAR(30), Phone VARCHAR(16) ) GO ALTER TABLE Contacts ADD ContactID INT IDENTITY(1, 1)

Read more about this topic:  Identity Column

Famous quotes containing the words code and/or samples:

    “Wise Draco comes, deep in the midnight roll
    Of black artillery; he comes, though late;
    In code corroborating Calvin’s creed
    And cynic tyrannies of honest kings;
    He comes, nor parlies; and the Town, redeemed,
    Gives thanks devout; nor, being thankful, heeds
    The grimy slur on the Republic’s faith implied,
    Which holds that Man is naturally good,
    And—more—is Nature’s Roman, never to be
    scourged.”
    —Herman Melville (1819–1891)

    “Good government cannot be found on the bargain-counter. We have seen samples of bargain-counter government in the past when low tax rates were secured by increasing the bonded debt for current expenses or refusing to keep our institutions up to the standard in repairs, extensions, equipment, and accommodations. I refuse, and the Republican Party refuses, to endorse that method of sham and shoddy economy.”
    —Calvin Coolidge (1872–1933)