Wednesday, March 21, 2012

How to detect that a sqlserver table row has foreign keys and cannot be deleted?

What is the best way to detect that a sqlserver table row has foreign keys and cannot be deleted?

Thanks,

Keith

sp_table_constraints_rowset 'yourTableName'

No comments:

Post a Comment