how many tables we can create in a particular sql server database

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Bhavesh-257515 SSC Enthusiast Points: 199 More actions · Answer 1

SSC Enthusiast

Points: 199

December 28, 2005 at 1:18 am

up to two billion tables per database

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Check out "Maximum Capacity Specifications" in BOL.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 3

noeld SSC Guru Points: 96590 More actions · Answer 4

SSC Guru

Points: 96590

December 28, 2005 at 1:19 pm

2,147,483,647

* Noel

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 5

... or 2^31 ...

... however anything nearing that capacity I'd like to hear about --> just so I can know where it is and never have to see it !

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 6

Indeed. I'd think if you got over 10k tables you'd be asking for trouble.