i have a bunch of user-defined table TYPES, to which i am doing table-valued parm insertions.
suddenly the table def needs to change, and i need to put FK's on two values within the target tables, that are written to with these TVP's.
i can put FK's on the target tables, right? they needn't go on the TYPE tables, too, do they?
what's the best way to handle that?