如果要重命名的对象是一个约束object_name必须在窗体schema.constraint。 -- item type determined? if(@objtypeisnull) begin COMMITTRANSACTION raiserror(15225,-1,-1,@objname,@CurrentDb,@objtypeIN) return1 end 参考资料: https://docs.microsoft.com/zh-cn/sql/relational-databases/system-stored-procedu...
如果要重命名的对象是一个约束object_name必须在窗体schema.constraint。 --itemtypedetermined?if(@objtypeis null)beginCOMMITTRANSACTIONraiserror(15225,-1,-1,@objname,@CurrentDb,@objtypeIN)return1end 参考资料: https://docs.microsoft.com/zh-cn/sql/relational-databases/system-stored-procedures/sp-rena...
如果要重命名的对象是一个约束object_name必须在窗体schema.constraint。 -- item type determined? if(@objtypeisnull) begin COMMITTRANSACTION raiserror(15225,-1,-1,@objname,@CurrentDb,@objtypeIN) return1 end 参考资料: https://docs.microsoft.com/zh-cn/sql/relational-databases/system-stored-procedu...
名前を変更するオブジェクトが制約の場合、 object_name はschema.constraint の形式である必要があります。 引用符は、修飾オブジェクトを指定する場合のみ必要です。 データベース名を含む完全修飾名を指定する場合、データベース名は現在のデータベースの名前である必要があります。 object_name は...
TSqlStatement TSqlStatementSnippet TSqlTokenType TSqlTriggerEventGroupHelper TSqlTriggerEventTypeHelper UnaryExpression UnaryExpressionType UniqueConstraintDefinition UniqueRowFilter UnpivotedTableReference UnqualifiedJoin UnqualifiedJoinType UpdateCall UpdateDeleteSpecificationBase UpdateForClause UpdateMergeAction UpdateS...
TSqlStatement TSqlStatementSnippet TSqlTokenType TSqlTriggerEventGroupHelper TSqlTriggerEventTypeHelper UnaryExpression UnaryExpressionType UniqueConstraintDefinition UniqueRowFilter UnpivotedTableReference UnqualifiedJoin UnqualifiedJoinType UpdateCall UpdateDeleteSpecificationBase UpdateForClause UpdateMergeAction Up...
AND type IN ('C','F', 'PK'); GO -- Rename the primary key constraint. sp_rename 'HumanResources.PK_Employee_BusinessEntityID', 'PK_EmployeeID'; GO -- Rename a check constraint. sp_rename 'HumanResources.CK_Employee_BirthDate', 'CK_BirthDate'; ...
Elizabeth Ayer is the Product Manager for SQL Source Control with Redgate, where she previously worked on .NET and Exchange tools. In addition to her day job, she now writes and speaks on Continuous Delivery and Database Lifecycle Management. Before turning to product...
TfsHostTypeConstraint, classe TFSProvider, classe TokenRename, classe TokenRenameTable, classe TokenTable, classe TooManyItemsException, classe TraceDefinition, classe TraceEvent, structure TraceFilter, classe TraceFilterAttribute, classe TracePointRange, classe TraceWatch, classe UnauthenticatedIdentityProvider...
PrecedenceConstraint PredictFunction PredictQueryBuilder PreserveCase PreviewAnimatedTransition PreviewCode PreviewSideBySide PreviewTab 上一個 PreviousBookmark PreviousBookmarkInFile PreviousBookmarkInFolder PreviousError PreviousFrame PrimaryKeyError PrimaryKeyWarning 列印 PrintDialog PrintDirect PrintDocument PrintPreview...