pmp_create_table.sql

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