Congratulations - C# Corner Q4, 2022 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forum guidelines
Rahul Chauhan
1.8k
429
18.6k
I Have an doubt with unique, primary and foreign key?????
Jun 24 2021 10:55 AM
Primary Key
:-
The primary key is uniquely identifier in the table
The primary key is not more than once in the table.
The primary key needs a UNIQUE value and is not null.
Foreign key:-
The foreign key is used to make link b/w more than one table.
The foreign key is field/collection of fields which are primary key in another table fields.
Unique Key
:-
The Unique key is same like primary key provide feature of uniqness .
All Value are different and unique in unique key fields.
So my question is that----
there are any simple definition to define primary, foreign, and unique key
in one paragraph????
What is different b/w Primary and foreign key????
What is different b/w Primary and Unique key????
What is different b/w Foreign and Unique Key????
Reply
Answers (
4
)
What we can change Ordinal Position of any column ?
how to alter column size sysntax in SQL Server 2000 version