Im having an mssql-database with six schemas which contains a different number of tables (from 100 to 20). The tables in the schemas are part of the same database, that is, queries are performed via joins on several of them. Would it be a good idea to merge them into one schema? Is there any good reasons for keeping them the way they are?
No, its not broken; it's just a question what 's the best way to design the database. For historical reasons, the database i splitted in six schemas, but for simpler administration, I would like to merge them. But, Im not sure its a good idea. At the moment, the database contains no foreign keys. Is that possible between schemas?