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:

    Many people will say to working mothers, in effect, “I don’t think you can have it all.” The phrase for “have it all” is code for “have your cake and eat it too.” What these people really mean is that achievement in the workplace has always come at a price—usually a significant personal price; conversely, women who stayed home with their children were seen as having sacrificed a great deal of their own ambition for their families.
    Anne C. Weisberg (20th century)

    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)