rati0090 (10/23/2012)
gud 1 but it should be 253 as their is a limit of 253
This is the recommended maximum limit, but you can have infinite number of FK constraints in such scenario. BOL has specifically mentioned the reason for this recommended max limit: "Depending on the hardware configuration hosting SQL Server, specifying additional FOREIGN KEY constraints may be expensive for the query optimizer to process"
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter