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

Suleyman Baysal 21 Reputation points
2021-03-01T04:32:24.95+00:00

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
    2021-03-01T07:56:41.187+00:00

    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