Geeks With Blogs
Pankaj Sharma Staying Connected In A Disconnected World... August 2011 Entries
Altering or extending the definition of implicitly named Check contraint in sql server
Recently i caught in a peculiar situation where i need to modify the check constraint expression to include more criteria to be validated through T-SQL. Although there is no declarative command or mechnism to modify the expression except dropping and recreating the check constraint. One exception is to use the Sql Management studio to modify it in design mode. But modifying using design mode was out of scope. The actual work was to alter or modify the defintion of a check constraint created with ......

Posted On Sunday, August 14, 2011 2:56 PM

Copyright © pankajsharma | Powered by: