SQL File Tables

Question

Hello team,

We are planning to use SQL FIle table. I ahve two queries

1.Can we overwrite the file in a directory using update sql script. If yes, please help me with script

1. We will use this file table to read and write the contents of file in net core application.
   If I deploy this solution as docker container in linux, will I be able to read the contents of file in SQL file table. Please help

Thanks
Athulya

Answer 1

Hi @Athulya Pillai ,

You can use the update statement to update directly：UPDATE (Transact-SQL)
As pituach said,Linux does not currently support Filetable.

If you have any question, please feel free to let me know.

Best Regards
Echo

Answer 2

Good day,

Can we overwrite the file in a directory using update sql script. If yes, please help me with script

Yes. The update script is like any simple UPDATE script

Check the documentation: FileTables can also be queried and updated through normal Transact-SQL access. They are also integrated with SQL Server management tools, and features such as backup.

This is what make this feature so useful :-)

If I deploy this solution as docker container in linux...

Filetable and FILESTREAM are not supported on linux as describe in the documentation:

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2019?view=sql-server-ver15#Unsupported