view with constraint

Go down

view with constraint

Post by jeeva on Wed Mar 24, 2010 1:53 pm

how to create a view with a READONLY constraint!!!

jeeva

Posts : 50
Points : 93
Join date : 2010-03-04

View user profile

Back to top Go down

Re: view with constraint

Post by mightyganesh on Wed Mar 24, 2010 2:21 pm

the syntax is

CREATE VIEW <viewname> AS <sub query> WITH READ ONLY ;

WITH READ ONLY clause at the end add the constraint!
avatar
mightyganesh

Posts : 53
Points : 92
Join date : 2010-02-26
Age : 30

View user profile http://ganeshguna.blogspot.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum