Hi Bob,

Well, I didn't know I'd need the name of the DEFAULT contraint. I converted this database from VFP and didn't see the need for sp_bindefault when the DEFAULT clause was available. Especially since it wasn't dynamic. i.e. If I changed the default, the table didn't reflect the change. Also, in VFP ALTER TABLE is alot more powerful (read, does more for me <G>). So much more to learn... especially best practices.

>Why not just name the constraint yourself, then you will know the name?
>
>>Hi All,
>>
>>Is there a way to find out the name of the Default Constraint that is created when you use the DEFAULT Clause of the CREATE TABLE statement?
>>
>>I haven't been able to find them in the INFORMATION_SCHEMA views. Currently, I ALTER the column and then cut and paste the name. I'd like to automate this in a stored procedure.
>>
>>TIA,