number of tables in MS Sql

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

1.How many no of tables that can be created with in a MS SQLdatabase ?

-- Anonymous, April 26, 2004

Answers

Philip,

Database objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. The sum of the number of all these objects in a database cannot exceed 2,147,483,647.

Hope this helps,

Eric

-- Anonymous, May 21, 2004


Moderation questions? read the FAQ