use dbSecretariat22
CREATE TABLE dbo.tblStudents1234
( nrleg char(8) PRIMARY KEY,
nume varchar(35) NOT NULL,
initiate varchar(8),
prenume varchar(35) NOT NULL,
Sex char ( 1 ) NOT NULL DEFAULT ( ' F ' ),
datanastere datetime,
starecivila char(1) NOT NULL DEFAULT('N')
) ON [PRIMARY]

CREATE TABLE  tbltelefonstuds1234(
nrleg char(8) NOT NULL Foreign key(nrleg) references tblStudents123(nrleg)
on delete cascade on update cascade,
Nr_telefon varchar(10),
interior varchar(4),
observatii varchar(30)
)
GO
ALTER TABLE tbltelefonstuds1234
ADD CONSTRAINT conTel_FK
FOREIGN KEY (nrleg) REFERENCES tblStudents1234(nrleg)
ON DELETE CASCADE ON UPDATE CASCADE
GO

EXEC sp_help tbltelefonstuds1234
exec sp_helpconstraint tbltelefonstuds1234