Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE dbo.pt1
(
nim int NOT NULL,
nama varchar(50) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.pt1 ADD CONSTRAINT
PK_pt1 PRIMARY KEY CLUSTERED
(
nim
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE TABLE dbo.pt2
(
nim int NOT NULL,
nama varchar(50) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.pt2 ADD CONSTRAINT
PK_pt2 PRIMARY KEY CLUSTERED
(
nim
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE TABLE dbo.pt3
(
nim int NOT NULL,
nama varchar(50) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.pt3 ADD CONSTRAINT
PK_pt3 PRIMARY KEY CLUSTERED
(
nim
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
CREATE TABLE dbo.all_pt
(
nim int NOT NULL,
pt int NOT NULL,
nama varchar(50) NOT NULL
) ON [PRIMARY]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.