> The constraint is a key (primary, foreign or unique), if you do not > specify it explicitly in the plan on the view definition there is no > dependency. > > When you execute a query the engine you check the available indices and > use the best for the query, if you droped some constraint the index will > not be available, and so, not be used. > > So, answering your question, you are right, you will have no dependency > problem. >
Hello and thanks for your reply. I've recreated all views without a custom PLAN statement now.
