CODEWITHSUNDEEP
sql-server-2012sql-server-2014
Vikrant More
Vikrant More

Reputation: 5442

how many FileTables we can create in SQL Server 2012?

i am using SQL Server 2012 and would like to implement FileTables feature in application. how many FileTable we can create in one Database in SQL Server 2012?

Upvotes: 0

Views: 94

Answers (1)

Jaype
Jaype

Reputation: 26

The number of tables allowed in a single database is limited to the total number of object, which can't exceed 2,147,483,647. I've never run across any article that diferentiates between regular tables and file tables.

http://msdn.microsoft.com/en-us/library/ms143432(v=sql.110).aspx

Upvotes: 1

Related Questions