March 28, 2012 at 8:11 am
I am looking at one of our tables that has a column with a default value set.
When I right click on the table and go to Design it shows a Default value or binding as I would expect it to for that column.
When I right click on the table in Object Explorer, expand the table, expand the columns, right click on the column, go to Properties and look at "Default Binding" that field is blank.
I thought these were effectively the same information that was supposed to be represented between the two.
Am I missing something or not understanding the meaning of these?
Thanks!
March 28, 2012 at 1:23 pm
Maxer (3/28/2012)
I am looking at one of our tables that has a column with a default value set.When I right click on the table and go to Design it shows a Default value or binding as I would expect it to for that column.
When I right click on the table in Object Explorer, expand the table, expand the columns, right click on the column, go to Properties and look at "Default Binding" that field is blank.
I thought these were effectively the same information that was supposed to be represented between the two.
Am I missing something or not understanding the meaning of these?
Thanks!
"Default Binding" is different from "Default Value". You are seeing the "Default Value" in the "Default Value or Binding" field when in Table Design Mode. The filed in the Column properties is labeled simply "Default Binding". If there were a DEFAULT bound to the column you would see that shown in both places. It's a UI limitation.
Read more on the DEFAULT object here: CREATE DEFAULT (Transact-SQL) (Note, DEFAULTs are deprecated).
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply