CODEWITHSUNDEEP
sqlsql-serverdataverse
Jonathan
Jonathan

Reputation: 451

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?

Upvotes: 0

Views: 1085

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89036

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

Upvotes: 1

Related Questions