constraints to views

From: Nandakumar <N.Kumar_at_rocketmail.com>
Date: Tue, 24 Aug 1999 17:22:18 GMT
Message-ID: <7pukc5$7gu$1@nnrp1.deja.com>

If a view is created over a table that has no constraints, is it possible to attach some constraints to the view.

Say 'tableA' has four fields F1,F2,F3,F4. A view 'viewA' is created with F1 and F2. I want to create a constraint NOT NULL to F1 and F2 to 'viewA'. ie tableA can accept NULL values to F1 and F2 thru' other views. But inserting NULLs to F1 and F2 through 'viewA' is not allowed.

Could anyone give the ways to do it without using triggers?

--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 24 1999 - 12:22:18 CDT