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..:?:
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.
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.