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

Subscribe to our news:
Partners
Testimonials
Kevin Settler: "If you need the job done right and on time, do it with MS SQL Maestro on your team. The software is a pleasure for us. SQL Maestro Group do excellent work and are dedicated to producing products that all can be proud of".
Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

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