TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
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
Forums
Monthly Leaders
Forum guidelines
Pankaj Kumar Choudhary
71
26.6k
13.4m
Primary Key
May 21 2015 10:02 AM
Hello Friends I have a problem so please help me.
My problem is that we all know that is a table contain a primary key then a clustered index in generate. A Clustered Index is a special type of index that reorders the way records in the table are physically stored. Therefore the table can have only one Clustered Index.
If a have a table
and i create a primary key on Emp_Id cloumn then a B-Tree will generate(in Clustered Index)
that store the data in such a way
We know that in clustered index data always store in sorted form. Sorting always performed on the base of primary key.
My Confusion that how data will be sort if we create a primary key on more than one column
like:
Alter
Table
Employee
Add
constraint
Constraint_Name
Primary
Key
(
Emp_IId
,Emp_Age
)
Please anyone can explain me how data will be store in sorted form........
Thanks@@
Reply
Answers (
3
)
This Is Access Query: Want Sql Query:
set column autogenerate numbers