I am creating a table in the Table Explorer that the key field is defined as a "uniqueidentifier" field. In order to get this field to populate, you must set the default value to the SQL built-in function NewID(). When I set this in the properties, it puts quotes around it so that it appears in the properties as 'NewID()'. When this is saved to SQL, it shows as ('newid()'), which doesn't work. I have to go into the Management Studio and manually change the "Default Value or Binding" to NewID().

Is there a better way to do this or is there a problem here between DF and SQL?

This is DF190B2.

Steve Walter