I have downloaded a project (file table) from GITHUB, now I have my File tables in SQL Sserver.
I have added a type named filestream to my FileTableDBNew which is my current database that is holding the filetables.

Now there is an issue related to deleting a row from my filetable, the problem is that I can delete a record of data but I expect it to get deleted from the physical path on my computer, but somehow it doesn’t get deleted as I expected.

I have tried multiple ways such as giving all the permissions to all folders on my system, I have used a transaction as a command to delete a row and expect to not have it in the physical location, in SQL Server Configuration Management I have set all the configs related to filestream but it seems that none of them is working.

I’m glad to see any suggestions that might solve my problem.