Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011
    Posts
    4

    Unanswered: Number of tables per schema

    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?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Is it broken?

    Users can be granted permissions at a schema level, so be sure to check for that, before making any changes.

  3. #3
    Join Date
    May 2011
    Posts
    4
    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?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    It is possible to add foreign keys that bridge schemas.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •