Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of setting the primary key in the database, which is very detailed and has a certain reference value. Interested friends must finish reading it!

How does the database set the primary key?

The method of setting primary key by SQL

Open [SQL Server Management Studio] management tool and connect to the database

[set primary key when creating a table]-Open the interface for creating a new table

1) expand the database where you want to create a new table

2) right-click the "Table" menu, and select "New"-> "Table".

[set primary key when creating a table]-set primary key

1) in the "New Table Interface", add the rows of two test columns

2) Select any row, right-click and select "set Primary key"

3) Joint primary key setting: press and hold the ctrl key, cooperate with the left mouse button, you can select several more lines, and then right-click to select [set primary key]

4) after adding the column, click the "Save" button, enter the "table name" in the pop-up box, and click OK.

The above is all the contents of this article "how to set the primary key in the database". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.