1and1 Help Centre Categories

print article

Add Primary/Unique Keys after Table Creations by myLittleAdmin

For Windows packages.

In this article you will be shown how you can add primary/unique keys to tables using myLittleAdmin.

Follow the steps below to create a primary key for an MS SQL table, requiring that a unique entry be placed into the specified field of the table.

Step 2
Click Databases, then select your database.
Step 3
Select Tables and click the name of table you wish to create the Primary key for.
Overview on tables included in the database
Overview on tables included in the database
Step 4
Click the yellow-star icon to the right of the Indexes table.
View on table > yellow star
View on table > yellow star
Step 5
  • Enter a name for the primary key.
  • Choose the field(s) that you want to set as the primary key.
  • Check the Primary box.
  • When finished, click Create.
New Index data to be entered and chosen > Create
New Index data to be entered and chosen > Create
For additional information, you may want to reference: