Creating database constraints on tables on the fly

I am creating tables from java on the fly as they are needed. Now to define constraints and indexes on these tables we need to come up with unique names.

I am planning to query the system views to get the constraint and index system views to get a list of all existing names and then come up with a random name and check against these values.

I am doing this since the table name itself might not be unique after being truncated to include the PK suffix.

Is there a be开发者_如何转开发tter way to do this.

---

Create a UUID but remove the non AlphaNumerics.