Truncate table Dataverse

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?

Answer

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.

Use SQL to query data