Vb.net Development and SQL Hints

Saturday, 15 October 2016

UNIQUE constraint on multiple columns

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT uc_PersonID UNIQUE (P_Id,LastName)
)
Posted by kanakaraj at 04:37
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

kanakaraj
View my complete profile

Blog Archive

  • ►  2021 (1)
    • ►  July (1)
  • ►  2020 (3)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2019 (7)
    • ►  November (7)
  • ►  2017 (12)
    • ►  August (1)
    • ►  June (3)
    • ►  May (4)
    • ►  April (3)
    • ►  March (1)
  • ▼  2016 (14)
    • ►  December (2)
    • ►  November (2)
    • ▼  October (10)
      • Sub Form
      • System name and IP Address
      • Wildcard Search (Text Update )
      • UNIQUE constraint on multiple columns
      • Update from Test Database to Running Database
      • SSRS Report LookUp
      • TextBox Numeric value
      • Unique Constraint - Alter Table
      • UNIQUE constraint on multiple columns
      • Upper Case
Watermark theme. Powered by Blogger.