Check constraint

Hi, i want to know if it's possible to have information about a
record, if this record is referenced by another record of another
table ?
Before deleting this record i want to know if another table is
reference it.
Escuse for my english,
SamuelA FOREIGN KEY constraint should do thsi for you.
CREATE TABLE Employees (...department INTEGER NOT NULL
CONSTRAINT FK_employees_dept REFERENCES Departments (department)...)
--
David Portas
SQL Server MVP
--

Check constraint

Hi, i want to know if it's possible to have information about a
record, if this record is referenced by another record of another
table ?
Before deleting this record i want to know if another table is
reference it.
Escuse for my english,
SamuelA FOREIGN KEY constraint should do thsi for you.
CREATE TABLE Employees (...department INTEGER NOT NULL
CONSTRAINT FK_employees_dept REFERENCES Departments (department)...)
David Portas
SQL Server MVP
--