sql server - vsdbcmd.exe generate drop constraint instructions without constraint name -


when generating diff script between 2 dbschema vsdbcmd.exe, sometime obtain unexpected output, containing drop constraint without name of constraint :

go print n'dropping on column: columnname ...';      go alter table tablename drop constraint ; 

in our schema, column has default value constraint, auto generated name. expected vsdbcmd.exe generate valid alter table sql statement, specified in msdn library :

alter table [ database_name . [ schema_name ] . | schema_name . ] table_name drop { [ constraint ] constraint_name | column column_name }

do have idea of prevent vsdbcmd.exe generate valid sql statement ?

this issue occurs when constraint has generated name. explicitly named constraint not impacted. therefore, solution name every constraint.


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -