I am trying to truncate a table in Dataverse, so I have installed SQL Server Management studio, selected my database, and ran the query TRUNCATE TABLE tablename However, I get the error:
Msg 40000, Level 16, State 1, Line 1
'TRUNCATE' statement is not supported. Line:1, Position:1
Is there something that I am missing?
>Solution :
The SQL Connection to Dataverse is read-only
The SQL connection provides read-only access to the table data of the
target Dataverse environment thereby allowing you to execute SQL
queries against the Dataverse data tables.