Change ID(int) to UUID I have a large database with many relationships. The database can be rebuilt and a migration script for an already existing data base

For security reasons, the URL should not show the ID(int) only UUID

Is there any good advice for such a situation?


converting all IDs to UUID(if so how to do it efficiently?)
can I create an additional column in each UUID table and use it at the address? (if so how to do it efficiently?)
other suggestions?
can I create an additional column in each UUID table and use it at the address?


You can add an alternate key using a UUID like this:

alter table SomeTable add uuid uniqueidentifier unique not null default newsequentialid() 


Which will add minimal overhead, and provide efficient single-row lookups.