Okei, thank for your post. I found something very interesting as below:

I just changed the post little bit to have a better reading....(oops fed up with formating the same...)

In our table,

If (Unique Clustered)

If (Non - Clustered - unique)

{

Btree- Non-clustered Key

Leaf-Non Clustered Key + Clustered Key

}

else if (Non - Clustered = NonUnique )

{

Btree- Non-Clustered Key + Cluster Key

Leaf-Non-Clustered Key + Cluster Key

}

if (Non-Unique Clustered)

If(Non - Clustered = Unique)

{

Btree- Non - Clusetered Key

Leaf - Non - Clusetered Key + Cluster Key + UQI

}

else if (Non - Clustered= non unique)

{

Btree- Non - Clusetered Key + Cluster Key + UQI

Leaf- Non - Clusetered Key + Cluster Key + UQI

}