Sql数据库选项设置记录

SQL2008 Tools->Designers->Table and Database Designers=>untick the 'Prevent saving changes that require table re-creation'


SQL2008:Back Up->Options->Set backup compression:Compress backup

对于有主外键关系的表注意是否要指定Cascade属性。双击Keys下面的某个外键关系,‘INSERT And UPDATE Specifical’选择 'Cascade'

原文地址:https://www.cnblogs.com/cw_volcano/p/2331569.html