Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
DavidNR: "MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".
Albert Rognan: "Thank you for this quick reply. I must say I am impressed of the number of functions that is available within this tool".

More

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