Hello,

I've created a table which implements Informational constraint as follows

create table tab1(SNum integer, Name char(30), constraint c1 check (Num > 10) no enforced enable query optimization)

(Not sure whether this implements informational constraint)

After inserting the following records
1, Abdul
2, Babu
3, Chand
11, Ravi
12, Ram

I feel that select statement on tab1 would return me the last 2 records, (11 Ravi and 12 Ram) as per the informational constraint. But I'm getting all the inserted records in the output.

Can any one help me on this?

Informational constraints are strictly to help the optimizer to understand the type of contents and values of the column and get better optimized queries

Otherwise, for your application/SQL resultset, informational constrains do not mean anything serious ..

HTH

Sathyaram

You can implement what you want through a view:

create view myview as select * from tab1 where num > 10

Then when you run you query, do it against the view:

select * from myview

should get you the results you want.

HTH

Andy