RajaSekar's Blog
SharePoint,.Net,SQL,LINQ,Orchard CMS Tips
Wednesday, 7 September 2011
Composite key in sql
Composite key:
Composite key has one or more attribute
of field.
Example:
CREATE
TABLE
SAMPLES
(
ID
NUMERIC
(
10
),
NAME
NVARCHAR
(
50
),
CCODE
NVARCHAR
(
50
)
PRIMARY
KEY
(
ID
,
CCODE
))
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment