All, I've just been trying to setup some updateable views using standard views and associated rules. Is there any possibility of when you open a view in the SQL editor the SQL for the associated rules also show up. It would seem to make sense. When a view is dropped the rules are silently dropped also so if you're not careful you loose them. (Happened once! :-()
Thanks for your attention. Regards, Ben ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
