>>>>Hi,
>>>>
>>>>Is there a way to create a script of all FK Constraints in a database such that I could apply this script to anther database? or the same database after some or all of the constraints are deleted?
>>>>
>>>>TIA.
>>>
>>>

>>>SELECT 
>>> OBJECT_NAME(f.rkeyid) PK_Table_name,
>>> c2.name PK_Column_name,
>>> OBJECT_NAME(f.constid) Constraint_name,
>>> OBJECT_NAME(f.fkeyid) FK_Table_name,
>>> c1.name FK_Column_name
>>>FROM dbo.sysforeignkeys f
>>>INNER JOIN dbo.syscolumns c1 ON c1.id = f.fkeyid AND c1.colid = f.fkey
>>>INNER JOIN dbo.syscolumns c2 ON c2.id = f.rkeyid AND c2.colid = f.rkey
>>>--where Object_Name(fkeyId) = 'Foreign Table Name' 
>>>ORDER BY PK_Table_name, FK_Table_name, FK_Column_name;

>>>
>>>Alternatively
>>>

>>>SELECT 
>>>    PK_Table  = PK.TABLE_NAME,    
>>>    PK_Column = PT.COLUMN_NAME, 
>>>    FK_Table  = FK.TABLE_NAME, 
>>>    FK_Column = CU.COLUMN_NAME, 
>>> 
>>>    Constraint_Name = C.CONSTRAINT_NAME 
>>>FROM 
>>>    INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C 
>>>    INNER JOIN 
>>>    INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK 
>>>        ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME 
>>>    INNER JOIN 
>>>    INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK 
>>>        ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME 
>>>    INNER JOIN 
>>>    INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU 
>>>        ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME 
>>>    INNER JOIN 
>>>    ( 
>>>        SELECT 
>>>            i1.TABLE_NAME, i2.COLUMN_NAME 
>>>        FROM 
>>>            INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1 
>>>            INNER JOIN 
>>>            INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 
>>>            ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME 
>>>            WHERE i1.CONSTRAINT_TYPE = 'PRIMARY KEY' 
>>>    ) PT 
>>>    ON PT.TABLE_NAME = PK.TABLE_NAME 
>>>-- optional: 
>>>ORDER BY 
>>>    1,2,3,4

>>
>>Thank you.
>
>You're welcome. I have My Projects folder organized. In particular, I have Meta-Data folder there. So, I just took two scripts I already have saved.

I want to be organized too. When I grow up I want to be like you :)