i want to delete or update a row in database using built-in database viewer. but no sql commands is working for me. only commands provided by viewer is working. unable to use query. I think that i am writing wrong syntax, please anybody know how to do something using attributes of entity in commands. Error: user lacks privilege or object not found: ID / Error Code: -5501 / State: 42501
To update attribute value in entity – UPDATE "Table name" SET "Ättribute name" = "Value”
To delete the entry- DELETE FROM "Table name" WHERE Ättribute name" LIKE '%%'