Maximum Number of Tables

Is there a limit to number of tables that can be in one database? I am
guessing it is aroung 32000 but would like confirmation. I have poorly
designed customer app that partitions the data by creating seperate tables
for each store and quarter.
currently they are at around 26000, they shouldn't hit the 32000 this year
but soon.The theoretical number of object in a database is some 2 billion (object id column datatype is an
int). So you won't hot the roof with 32000, but one would question the database design... ;-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:46136C93-BD0A-4438-899A-FB6A9724B67F@.microsoft.com...
> Is there a limit to number of tables that can be in one database? I am
> guessing it is aroung 32000 but would like confirmation. I have poorly
> designed customer app that partitions the data by creating seperate tables
> for each store and quarter.
> currently they are at around 26000, they shouldn't hit the 32000 this year
> but soon.|||On Wed, 1 Mar 2006 18:31:01 +0100, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:
>The theoretical number of object in a database is some 2 billion (object id column datatype is an
>int). So you won't hot the roof with 32000, but one would question the database design... ;-)
At least they didn't make individual databases instead, that limit is
32,767. 8-)
Roy Harvey
Beacon Falls, CT

Maximum Number of Tables

Is there a limit to number of tables that can be in one database? I am
guessing it is aroung 32000 but would like confirmation. I have poorly
designed customer app that partitions the data by creating seperate tables
for each store and quarter.
currently they are at around 26000, they shouldn't hit the 32000 this year
but soon.
The theoretical number of object in a database is some 2 billion (object id column datatype is an
int). So you won't hot the roof with 32000, but one would question the database design... ;-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:46136C93-BD0A-4438-899A-FB6A9724B67F@.microsoft.com...
> Is there a limit to number of tables that can be in one database? I am
> guessing it is aroung 32000 but would like confirmation. I have poorly
> designed customer app that partitions the data by creating seperate tables
> for each store and quarter.
> currently they are at around 26000, they shouldn't hit the 32000 this year
> but soon.
|||On Wed, 1 Mar 2006 18:31:01 +0100, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:

>The theoretical number of object in a database is some 2 billion (object id column datatype is an
>int). So you won't hot the roof with 32000, but one would question the database design... ;-)
At least they didn't make individual databases instead, that limit is
32,767. 8-)
Roy Harvey
Beacon Falls, CT

Maximum Number of Tables

Is there a limit to number of tables that can be in one database? I am
guessing it is aroung 32000 but would like confirmation. I have poorly
designed customer app that partitions the data by creating seperate tables
for each store and quarter.
currently they are at around 26000, they shouldn't hit the 32000 this year
but soon.The theoretical number of object in a database is some 2 billion (object id
column datatype is an
int). So you won't hot the roof with 32000, but one would question the datab
ase design... ;-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Thom" <Thom@.discussions.microsoft.com> wrote in message
news:46136C93-BD0A-4438-899A-FB6A9724B67F@.microsoft.com...
> Is there a limit to number of tables that can be in one database? I am
> guessing it is aroung 32000 but would like confirmation. I have poorly
> designed customer app that partitions the data by creating seperate tables
> for each store and quarter.
> currently they are at around 26000, they shouldn't hit the 32000 this year
> but soon.|||On Wed, 1 Mar 2006 18:31:01 +0100, "Tibor Karaszi"
<tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote:

>The theoretical number of object in a database is some 2 billion (object id
column datatype is an
>int). So you won't hot the roof with 32000, but one would question the database des
ign... ;-)
At least they didn't make individual databases instead, that limit is
32,767. 8-)
Roy Harvey
Beacon Falls, CT