在表中,想把其中2列或多列作為組合主鍵。
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsISPrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdsATOfd3bkFGazxCMx8VesATMfhHLlN3XnxCMwEzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5yN0YGO1QWZ3gDNkZzYyQzY1MGO4cTZjZjN3I2Y2MmY48CXxMzLcdDMxIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjL3M3Lc9CX6MHc0RHaiojIsJye.png)
CREATE TABLE [dbo].[T3]
(
[col1] NVARCHAR(10) NOT NULL,
[col2] NVARCHAR(10) NOT NULL,
[col3] NVARCHAR(10) NULL,
[col4] NVARCHAR(10) NULL
)
GO
ALTER TABLE [dbo].[T3]
ADD CONSTRAINT [PK__T3__0000000000000003]
PRIMARY KEY([col1],[col2])
GO
Source Code