Use teste
------------------------------------------------
CREATE TABLE Hostipal (
    ID int NOT NULL,
    Nome nvarchar(30) NOT NULL,
    CONSTRAINT PK_ID PRIMARY KEY (ID),
    );
------------------------------------------------
CREATE TABLE Paciente (
    PacienteId int NOT NULL,
    Nome nvarchar(30) NOT NULL,
    ID int NOT NULL,
    CONSTRAINT PK_PacienteId PRIMARY KEY (PacienteId),
    CONSTRAINT FK_ID FOREIGN KEY (ID)
         REFERENCES Hospital(ID)
);