SQLce create table "index field" explanation (SQL Management Studio) ?
- by bretddog
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);