>>>Hi,
>>>
>>>I have a table that some time ago was converted from the VFP database using VFP wizard. One of the fields (type char(1)) has the default set to dbo.dfit_eq_file_in_service (the name of the table is eq_file and the field name is "in_service"). I know I need to change this default to a literal. But where do I see the value of this ".dfit_eq_file_in_service"? TIA
>>
>>This is a user defined type and as we discussed this recently, this type of constants is being deprecated and the syntax to create them uses bind default. You better remove it and create the normal constant instead of the type.
>
>First, thank you all for your messages.
>
>Yes, I understand that these default constants are being deprecated. And I know what value gets inserted into the column. And I see in the design mode this default value as .'dflt_eq_file_in_service'. My question is where in the database this default is stored? That is, during the initial conversion of VFP to SQL Server, the VFP Wizard created this default and named it 'dflt_eq_file_in_service' with has a value of 'Y' and stored it somewhere. But where? (I am changing this constant but just curious of what happened before).

I've tested in SQL Server 2012 where I have a nice free add-on installed called SSMS Boost http://www.ssmsboost.com/

I found it in Programmability\Defaults by typing empty_char and then selecting locate object from the context menu (this is one of the options of this add-on).