Script to get all Primary and foreign Keys in a Database

list of primary keys info on database

select '

ALTER TABLE ['+t.table_name+'] ADD  CONSTRAINT ['+t.constraint_name+'] PRIMARY KEY CLUSTERED 

(

 ['+ u. COLUMN_NAME +'] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, 

SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON,

 ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]

GO' from INFORMATION_SCHEMA.TABLE_CONSTRAINTS t

, INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE u

where CONSTRAINT_TYPE = 'PRIMARY KEY' AND t.CONSTRAINT_NAME = u.CONSTRAINT_NAME

ORDER BY u.TABLE_NAME

list of foreign keys info on database

select '

ALTER TABLE ['+object_name(f.parent_object_id)+'] WITH NOCheck ADD  CONSTRAINT ['+f.name+'] FOREIGN KEY  

 ('+ COL_NAME(fc.parent_object_id,fc.parent_column_id) +') references ['+OBJECT_NAME (f.referenced_object_id)+'] 

 ('+COL_NAME(fc.referenced_object_id,fc.referenced_column_id)+') 

GO'

FROM sys.foreign_keys AS f

INNER JOIN sys.foreign_key_columns AS fc

ON f.OBJECT_ID = fc.constraint_object_id