REFERENCES permission

When does a REFERENCES permission come into play (is it for tables or procs etc)? what exactly does it mean?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
aelliso3Connect With a Mentor Commented:
FROM BOL ...
The REFERENCES permission on a table is needed in order to create a FOREIGN KEY constraint that references that table.
 
0
 
anushahannaAuthor Commented:
OK. so it is applicable only to tables?

for example, i want to create a PK-FK relationship between tblTracker (PK is TrackerPK) and tblTrackerRef (and FK is TrackerFK); so if I need to create the relationship then I need references permissions on tblTracker? Would that be right?
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
>so it is applicable only to tables?yes.and yes, your example is right.
0
 
anushahannaAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.