number of tables in MS Sqlgreenspun.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
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,
-- Anonymous, May 21, 2004