is it possible to create a view with a primary key.. if so... how can i do that using a query of t sql.. anyone.. help..:?:

Recommended Answers

What are you trying to do?

Jump to Post

All 4 Replies

how can i add a primary key on a view...

What are you trying to do?

im trying to create view on ms sql having a primary key.. is that possible

No. A view doesn't contain data so a primary key won't work.
Perhaps an indexed view will do the trick for you, depending on what you want to do.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.