APPEND BLANK
in VFP and programmatically fill the default values, but if I want to change a default, I have to recompile and besides I thought it would be best to use the SQLServer default values since I entered them there anyway!BEGIN TRANSACTION
>INSERT INTO table DEFAULT VALUES
>SELECT fieldlist FROM table WHERE idfield = @@IDENTITY
>ROLLBACK
Select column_name, column_default From information_schema.columns Where table_name="mytable"I found this through a message reference by Sergey :) HTH