Advertisement
Guest User

Untitled

a guest
Oct 24th, 2014
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. use DestDB
  2.  
  3. SELECT f.name AS ForeignKey,
  4. OBJECT_NAME(f.parent_object_id) AS TableName,
  5. COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,
  6. OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
  7. COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName
  8. FROM sys.foreign_keys AS f
  9. INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement