CREATE TABLE dbo.ptitle
(
   H_CODE VARCHAR(6) NULL,
   P_title VARCHAR(16) NULL,
   P_DATE VARCHAR(8) NULL,
   p_qualified VARCHAR(4) NULL,
   p_place VARCHAR(20) NULL
)

GO

CREATE INDEX H_CODE ON dbo.ptitle(H_CODE)

GO

CREATE INDEX P_TITLE ON dbo.ptitle(P_title)

END