kapil190588 (10/10/2012)
sorry I pasted wrong query-this is the query below in which I am getting error-
alter view chk_sales
as
select * from SalesDates,
add constraint chk_unique unique values (id>2)
You cannot create a constraint on the columns of a view.
Constraints belong on the base tables.
Views make use of predicates...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”