SQL Server Performance Forum – Threads Archive
How many schemas?
Do you know how many schemas you can create in a database? It is a large number, I presume, looking at the system table. I haven’t been able to find an authoritative answer to this question though (which was put to me by a developer).I think it is limited by objects in the databases. Database objects include objects such as tables, views, stored procedures, user-defined functions, triggers, rules, defaults, and constraints. The sum of the number of all objects in a database cannot exceed 2,147,483,647. —————————————-
Interesting question!<br />I also haven’t found any answer yet, but in any case I believe if you get anywhere near that limit, you certainly do have some other serious problems in your design. [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />–<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
quote:
I also haven’t found any answer yet, but in any case I believe if you get anywhere near that limit, you certainly do have some other serious problems in your design.
I also haven’t found any answer yet, but in any case I believe if you get anywhere near that limit, you certainly do have some other serious problems in your design.
yes, I don’t think you have to worry too much. practical point of view I am working in a db where you have 5 schemas. —————————————-
Yes, I agree, you’d never want it to get anywhere near the limit. Whatever it is!
may be a good question for an interview [<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />—————————————-<br /><br />
]]>