Home / server / Questions / 182182
Accepted
hjd
Asked: 2010-09-18 04:09:18 +0800 CST

Is there a maximum number of schemas allowed in SQL Server 2005?

  • 772

What is the maximum number of user schemas one can create in a single SQL Server 2005 database?

Is this figure different on SQL Server Express vs SQL Server Standard?

I've searched the MSDN documentation but can't find anything approaching an answer. The max capacity page at MSDN doesn't mention schemas.

sql-server-2005 schema maximum

1 Answers

  1. Best Answer

    Schemas are just objects in the databases so they fall under the maximum objects counters which have a limit of 2,147,483,647.

    It'll be the same for all editions of the engine.

    • 2