An urgent question, an entry question, thank you

unkmass

COLLATE Chinese_PRC_CI_AS
This can be removed and written like this:
Student number char (6) NOT NULL

lehmann

What does ALTER TABLE [dbo]. [Xs_kc] WITH NOCHECK ADD // WITH NOCHECK ADD mean?
CONSTRAINT [PK_xs_kc] PRIMARY KEY CLUSTERED // Why CLUSTERED ??
(
                [student ID],
[Course number]
) ON [PRIMARY]
GO

unkmass

Automatically generated after building the table with Enterprise Manager. Don't worry about it.
In fact, you can build tables with Enterprise Manager, and then generate SQL scripts, which have this function.

lehmann

What does ALTER TABLE [dbo]. [Xs_kc] WITH NOCHECK ADD // WITH NOCHECK ADD mean?
CONSTRAINT [PK_xs_kc] PRIMARY KEY CLUSTERED // Why CLUSTERED ??
(
                [student ID],
[Course number]
) ON [PRIMARY]
GO
I do n’t understand? ?

yfacmilan

Directly on the database-right-click-new table-fill in the fields, set the type length, set the primary key to save it

玛洛恩

The option when creating a table, without checking the existing data, directly add constraints.

玛洛恩

Clustered index

djazrael

CREATE TABLE dbo.XS_KC
(
Student number char (6) NOT NULL,
Course number char (3) NOT NULL,
Grade tinyint NOT NULL,
Credits tinyint NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.XS_KC ADD CONSTRAINT
PK_XS_KC PRIMARY KEY CLUSTERED
(
        student ID,
Course number
) ON [PRIMARY]

GO

unkmass

Arranged a bit:
CREATE TABLE xs_kc (
Student number char (6) NOT NULL,
Course number char (3) NOT NULL,
Score decimal (18, 0) NULL,
Credits int NULL,
CONSTRAINT PK_xs_kc PRIMARY KEY CLUSTERED (student number, course number),-primary key
CONSTRAINT FK_xs_kc_kc FOREIGN KEY (course number) REFERENCES dbo.kc (course number),-foreign key
CONSTRAINT FK_xs_kc_xs FOREIGN KEY (student number) REFERENCES dbo.xs (student number)-foreign key
)

unkmass

CREATE TABLE xs_kc (
Student number char (6) NOT NULL,
Course number char (3) NOT NULL,
Score decimal (18, 0) NULL,
Credits int NULL,
CONSTRAINT PK_xs_kc PRIMARY KEY CLUSTERED (student number, course number),-primary key
CONSTRAINT FK_xs_kc_kc FOREIGN KEY (course number) REFERENCES dbo.kc (course number),-foreign key
CONSTRAINT FK_xs_kc_xs FOREIGN KEY (student number) REFERENCES dbo.xs (student number)-foreign key
)