How to set a key in a view?

Question

SQL Server

I connect two tables in representation in both tables there are keys. How to set a key in a specific column in a view?

Answer 1

You need a materialized view, i.e. first create a cluster key on the view, then the desired key, you can combine this in one action.
Here about it:
https://msdn.microsoft.com/ru-ru/library/ms191432.aspx
But it is worth considering the pitfalls, for example, when updating one table, the view will also be updated. It will also not be so easy to change the structure of the tables that will be used in this view. There is more at the link above.

Answer 2

No way, this is a view, not a table, why are there keys?