SQL File Tables

Athulya Pillai 46 Reputation points
2020-08-27T07:45:48.73+00:00

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

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,536 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Ronen Ariely 15,081 Reputation points
    2020-08-27T08:07:07.607+00:00

    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

    20804-image.png

    0 comments No comments

  2. EchoLiu-MSFT 14,571 Reputation points
    2020-08-27T09:14:57.457+00:00

    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

    0 comments No comments