Database SAQL CC in Vault

[ambrosiPZ23D]

Dear experts,
I guess no one will answer me. Tabu'
But I still ask you anyway where the data is saved in the DB?
For example, I cannot find the PartNumber even if I scan the entire CC SQL DB.
I need it to set all the PartNumber names in one shot.
Thank you

[Frederick_Law]

What are you looking for?

Which CC library?

Some part number are generated.  So it'll be equation.

[ambrosiPZ23D]

I have to make massive changes to the PartNumber.

Most of CC family.

My PartNumber is not calculated

[Michael.Navara]

Never try to modify CC database directly. If you want to do some modification, use the API functions related to ContentCenter.

[ambrosiPZ23D]

ok but where can I find the PartNumber in the cc db vault?

even with a query in all the tables of the db I can't find it

[ambrosiPZ23D]

using VBA (maybe with VB it's better) with a Stored Procedure on SQL to update the PartNumber it takes me 30 minutes, if I could act directly in the SQL tables it would take me 30 seconds

[Frederick_Law · Accepted solution]

---

@ambrosiPZ23D wrote:

using VBA (maybe with VB it's better) with a Stored Procedure on SQL to update the PartNumber it takes me 30 minutes, if I could act directly in the SQL tables it would take me 30 seconds

---

Run it overnight?  Or on weekend?

You just need to run it once, right?

Not daily.

I use iLogic to make 100s of drawings.  5 minutes per drawing.  So I just run it overnight.