Can i create file table in another mdf file from same database?

Suleyman Baysal 21 Reputation points

I want to create file table but i dont want to locate with same standard tables. Because of that i want to create another mdf file for file tables. Is it possible?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,082 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 42,486 Reputation points

    You can not create a FileTable in a regular database file group at all, you have to create a FILESTREAM filegroup first, see Create, Alter, and Drop FileTables => Requirements and Restrictions for Creating a FileTable: "A FileTable requires a valid FILESTREAM filegroup, since a FileTable contains a FILESTREAM column."

    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful