Primary Key on View

[kingz2000]

I just wanted to know what I have done wrong in this statement, where I am trying to add a primary key to a view:

alter View MyView
add constraint prm_pk Primary Key(policy_no)
disable novalidate;

I get an syntax error message regarding the 'add'

I heard it is possible to set a view a primary key.Please tell me how it should be changed.Thank you!


Kingsley

 

[mrmitchmitchell]

Are you using ASA or ASE? What version?

I work in ASA V10 and the only way to do this is to declare your view and MATERIALIZED view.

Mitch