DiverKas (12/10/2008)
I selected True and was told I got it wrong. However, if I choose to make a column a GUID column, choose identity and select it to be RowGuidCol, it creates the newid function for me. SO in my mind, it is automatic. I would have to go and remove the newid function call from the default setting.I guess one could argue if you created a table in TSQL, it would not be default. But the question didnt say that.
Hi DiverKas
I see where you are coming from, I haven't used management studio to create tables for a while and I did the test as you mention and saw that when you specify the RowGuid it automatically specifies newid() as the default value or binding.
So I'm not sure if that is a managent studio feature to ease the creation of SQL tables, taking into account that according to the database engine it doesn't automatically generate values for the column?
This is my first question and was expecting different views aired, and this helps to think about formatting question wording for next time...:D