I have a table that has an ID column which is the primary key and I have the type set to uniqueidentifier. Now I want Sql Azure to populate this field for me with newid() however in the managment portal I can not enter anything into the Default Value slot. So I tried to manually add the constraint to the column using managment studio. It takes however when I go to actually insert a row it complains saying ID can not be null. When I go back to the managment portal and look at the table it has <unsupported> in as the default value.
How can I get sql azure to generate a uniqueidentifier? is this not supported? if its not supported would it be bad to have a varchar(36) and populate that with newid() instead?
Thanks,