Mikhail Gorbachev's policies of glasnost and perestroika had profound and unintended effects on the Soviet Union. In fact, many historians suggest these reforms led directly to the fall of communism and the breakup of the Soviet Union.
In SQL Server, you create a surrogate key by assigning an identity property to a column that has a number data type. A natural key is a naturally occurring descriptor of the data and one of a table's attributes that has no duplicate values. When you use a natural key as a table's primary key, each of the table's rows is uniquely identified.
To modify a primary key. Open the Table Designer for the table whose primary key you want to modify, right-click in the Table Designer, and choose Indexes/Keys from the shortcut menu. In the Indexes/Keys dialog box, select the primary key index from the Selected Primary/Unique Key or Index list.Complete an action from the following table: To. Follow these steps. Rename the primary key. Type a new name in the Name box.Make sure that your new name does not duplicate a name in the Selected Primary/Unique Key or Index list. Set the clustered option. To create a clustered index for the primary key, select Create as CLUSTERED, and select the option from the drop-down list box.ype a new name in the Name box. Make sure that your new name does not duplicate a name in the Selected Primary/Unique Key or Index list. Set the clustered option. To create a clustered index for the primary key, select Create as CLUSTERED, and select the option from the drop-down list box.