Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Paolo Benjamin T. Briones: "I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".
Tracy J Powell: "Thank you VERY much for the quick and helpful response. I will definitely upgrade as soon as possible. Your products are great and I use them daily".


Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

File Tables

File tables brings support for the Windows file namespace and compatibility with Windows applications to the file data stored in SQL Server. You can store files and documents in special tables in SQL Server, but access them from Windows applications as if they were stored in the file system, without making any changes to your client applications. Find out more on file tables in Microsoft SQL Server community.


A file table is a specialized user table that has a pre-defined and fixed schema. This schema stores FILESTREAM data, file and directory information, and file attributes. To add a new file table, you need to specify the directory that serves as the root directory for all the files and directories stored in the file table as File Name Directory Name, and the name of the collation to be applied to the Name column in the file table as File Name Column Collation. If you do not provide a directory name when you create the file table, then the name of the file table itself is used as the directory name.


After the creation, file tables are available to use as ordinary database tables. You can work with their data within the corresponding editor as usual: load files to tables, query, export, and import tables data and as well as through the Windows file system.


Prev Return to chapter overview Next