database viewer

0
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    
asked
1 answers
1

Hello Lalit,

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 '%%'

Hope it helps!!

Thanks

 

answered