Constraints

Hi,
What all things are required to be known abt a constraint (FKey) inorder to
re-create it perfectly after dropping it?
I make that sure from the following information schemas : INFORMATION_SCHEMA
.REFERENTIAL_CONSTRAINTS,
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE and INFORMATION_SCHEMA.COLUMNS
Could anyone guide me if i'm on the right track?Hi,
Have a look into books online for the system procedure SP_FKEYS
Thanks
Hari
MCDBA
"Sheetal" <anonymous@.discussions.microsoft.com> wrote in message
news:89BEB1F5-34A9-40BF-8323-E99D7054D4FF@.microsoft.com...
> Hi,
> What all things are required to be known abt a constraint (FKey) inorder
to re-create it perfectly after dropping it?
> I make that sure from the following information schemas :
INFORMATION_SCHEMA. REFERENTIAL_CONSTRAINTS,
> INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE and
INFORMATION_SCHEMA.COLUMNS
> Could anyone guide me if i'm on the right track?