How can I create a unique constraint on my column in SQL Server?

The UNIQUE constraint ensures that all values in a column are different.
Both the UNIQUE and PRIMARY KEY constraints provide a guarantee for uniqueness for a column or set of columns.
A PRIMARY KEY constraint automatically has a UNIQUE constraint.
However, you can have many UNIQUE constraints per table, but only one PRIMARY KEY constraint per table.


CREATE TABLE Persons (
    ID int NOT NULL UNIQUE,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);

SQL UNIQUE Constraint on ALTER TABLE


ALTER TABLE Persons
ADD UNIQUE (ID);

Comments

Post a Comment

Popular posts from this blog

What is the difference between asynchronous and synchronous execution?

When you execute something synchronously, you wait for it to finish before moving on to another task. When you execute something asynchronously, you can move on to another task before it finishes. That being said, in the context of computers this translates into executing a process or task on another "thread." A thread is a series of commands (a block of code) that exists as a unit of work. The operating system can manage multiple threads and assign a thread a piece ("slice") of processor time before switching to another thread to give it a turn to do some work. At its core (pardon the pun), a processor can simply execute a command, it has no concept of doing two things at one time. The operating system simulates this by allocating slices of time to different threads. Now, if you introduce multiple cores/processors into the mix, then things CAN actually happen at the same time. The operating system can allocate time to one thread on the first processor, then a
Read more

Yahoo accepting requests for inactive email IDs

Image
Yahoo accepting requests for inactive email IDs SAN FRANCISCO:  Yahoo  is allowing people to place claims on inactive  email  addresses that are being given a second life.  The opportunity to request the identifications began Monday afternoon and will extend through Aug. 7. Up to five different names can be submitted at http://wishlist.yahoo.com .  Yahoo Inc. says a substantial number of old email IDs are being made available, but isn't providing specifics.  The email IDs are being released a month after the Sunnyvale, California, company notified users that they would have 30 days to log into an inactive account if they wanted to keep it.  People awarded the rights to the recycled email addresses will have a 48-hour period to activate the accounts beginning Aug. 15
Read more

Badtameez Dil Lyrics--Yeh Jawaani Hai Deewani Song

Badtameez Dil Lyrics Badtameezee ek bimari hai Ek aisi bimari Jo dheere dheere waqt ke saath Budhaape mein badal jaati hai Main kehta hoon jab tak budhaapa nahi aata Thodi badtameezee hi kar lete hai Paan main pudeena dekha Naak ka nageena dekha Chikni chameli dekhi  Chikna kameena dekha Chaand ne cheater hoke cheat kiya toh Saare taare bole gilli gilli akhaa Pa para para... Meri baat, teri baat Zyada baatein boori baat Thaali mein katora leke Aaloo bhat, Muri bhat Mere peeche kisi ne repeat kiya toh Saala maine tere muh pe maara mukka Ispe bhoot koi chadha hai Theharna jaane naa Ab toh kya buraa kyaa bhalaa hai Fark pehchaane naa Zidd pakad ke khadaa hai kambakht Chhodna jaane naa Badtameez dil, batameez dil, batamiz dil Maane na, maane na Badtameez dil, batameez dil, batamiz dil Maane na, maane na Yeh jo haal hai, sawaal hai, kamaal hai Jaane na jaane na Badtameez dil, battameez dil badtameez dil Maane naa.. Hawa mein Havana dekha Dhimka falaana dekha Seeng ka Singhara khaake She
Read more