Hi, I'm new to databases, and now creating SQLCE database in Management Studio. There is a value in brackets; [UQ_Users_0000000000000028], which seems a bit random to me, so would just like to ask if someone could explain this field?

Is it just simply required to be a unique field? Is there any reason why I would want to change it to something else than what SSMS scripts?

cheers!

CREATE TABLE [Users] (
  [UserID] int NOT NULL
.....
CREATE UNIQUE INDEX [UQ__Users__0000000000000028] ON [Users] ([UserID] ASC);