SQL deletion of xProperties

Hello, 

After many tets I want to clean up may database, specialy the xProperties. 

I run the following SQL : 

DELETE 
FROM [InnovatorSolutions].[xp].[XPROPERTYVALUES]
where item_id='0422C7B455E741D08263B1B91D0C3DDE'

where  0422C7B455E741D08263B1B91D0C3DDE is the id of my Item .

but.... the xproperties still apear in my Item !!

Nota : before deleting the record i made a update of a xPropertiy in the record and the  new values appear in the Item . 

Will the xProperties still aprears ? In wich (other) table the xProperties were strored ? 

Thanks in advance !

Parents
  • First, let’s quickly review what an SQL delete statement looks like. We need to tell the database and table from where it should delete the data. It’s a good idea to add a condition clause to set the scope of data deletion. Otherwise, it will delete everything in the table.

    myaarpmedicare

Reply
  • First, let’s quickly review what an SQL delete statement looks like. We need to tell the database and table from where it should delete the data. It’s a good idea to add a condition clause to set the scope of data deletion. Otherwise, it will delete everything in the table.

    myaarpmedicare

Children
No Data