Member Avatar for rockout15

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..:?:

  • 2 Contributors
  • 4 Replies
  • 83 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by adam_k
Member Avatar for rockout15

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

Member Avatar for adam_k

What are you trying to do?

Member Avatar for rockout15

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

Member Avatar for adam_k

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.