Una diferencia primaria entre opciones de acciones e indices de acciones es

SalesOrderHeader table, the relational integrity between the two tables is broken; the deleted salesperson's sales orders are orphaned in the SalesOrderHeader table without a link to the data in the SalesPerson table. The following table summarizes the allowed actions on nonclustered indexes. Allowed actions on nonclustered indexes associated with a clustered index depend on the state, whether disabled or enabled, of both index types. If clustered or nonclustered is not specified for a primary key constraint, clustered is used if there no clustered index on the table.

SalesOrderHeader table has a foreign key link to the Sales. All the values that make up the foreign key are set to their default values if the corresponding row in the parent table is updated or deleted. The following table lists the common tasks associated with primary key and foreign key constraints.

This column, or columns, is called the primary key PK of the table and enforces the entity integrity of the table. When the clustered index is disabled or enabled and the nonclustered index is disabled, the clustered index action has the following results on the disabled nonclustered index. To remove an index from the Indexes to rebuild grid, select the index and then press the Delete key.

Eliminar relaciones entre claves externas. Is rebuilt and enabled. Ver las propiedades de clave externa View Foreign Key Properties.

In the Rebuild Indexes dialog box, verify that the correct index is in the Indexes to rebuild grid and click OK. Este tema contiene las siguientes secciones. After an index is disabled, it remains in a disabled state until it is rebuilt or dropped. Delete Foreign Key Relationships. The Motor de base de datos Database Engine raises an error and the delete or update action on the row in the parent table is rolled back.