Activity overview
Latest activity by cjoyce
Hi Dan,
I am particularly interested in "CONSTRAINT [DF__tmp_rg_xx__check__2CF2ADDF]" - I added the DEFAULT(0) myself because it will be required to update tables with existing data. With that being said, I created a simple script on my own (with SQL Compare) to add a column and executed it. It turns out that SQL Compare still reports a constraint being added to the column so maybe this isn't related to your product. Would SQL Server being doing this? Oddly enough, if I use Enterprise Manager's "Generate SQL" command, it doesn't include this contraint in the column's definition. Any thoughts as to where you are reading this constraint?
Thanks,
Chris / comments
Hi Dan,
I am particularly interested in "CONSTRAINT [DF__tmp_rg_xx__check__2CF2ADDF]" - I added the DEFAULT(0) myself because it will be required to update tables with existing data. With that bei...
Problem adding a column to an existing table
I want a simple script that adds a new column of type bit to my SQL Server database table. I have version 3.1.0.151 of SQL Compare. After running the script generated by SQL Compare, I notice in ...