In SWQL studio , i see the entity value of "can delete" property of a table set to False, i want to run a script that will delete an entry from this table.Is there any way to achieve it.
in SWQL you're fairly limited on deletes. Probably works, depends what the object is. I dont think you could or should delete a whole table.
Could do whatever in SQL if you had to
What is it you are trying to delete?
There's no such capability as DELETE FROM Entity.Name WHERE [Property] = 'Thing' - depending on the scripting language or method of connecting, there are different ways.
DELETE FROM Entity.Name WHERE [Property] = 'Thing'
A couple examples from the top of my head:
Remove-SwisObject -SwisConnection $SwisConnection -Uri $UriOfThingToDelete
delete
bulkdelete
swis.delete(SingleUriToDelete)
swis.bulkdelete(ArrayOfUrisToDelete)