I have created a parent table P in one Database and i have created the child table C in another database with Delete rule and everything works fine. I created like this thinking people want to create child tables that have LOB columns in different DB that have more space.
Is this a general practice that people do create their children under different database or 99% of the times they create the parent and the child under the same database?.