how many tables you can create in sql server database?

Question

how many table possible to create in one database?

Answer 1

There's no (practical) limit. Most likely, you'll run out of space before it becomes an issue.

Answer 2

If you use a foreign key with a unique constraint, you can have only 1 entry with a null value.. for example CREATE TABLE Category ( ID INT NULL PRIMARY KEY ) CREATE TABLE SubCategory ( CategoryID INT NOT NULL FOREIGN KEY REFERENCES (Category.ID) ) You can insert records on SubCategory with a null value for CategoryID, but 1 entry on Category can have the ID null

Answer 3

I believe there is an infinite limit, the only restriction being hard drive storage you have available.