سلام میخواستم بدونم یک موجودیت چند ارجاع به خودش میتونه داشته باشه؟
سلام میخواستم بدونم یک موجودیت چند ارجاع به خودش میتونه داشته باشه؟
از مایکروسافت:
https://technet.microsoft.com/en-us/...=sql.105).aspx
Number of FOREIGN KEY Constraints in a Table
SQL Server does not have a predefined limit on either the number of FOREIGN KEY constraints a table can contain (which reference other tables), or the number of FOREIGN KEY constraints owned by other tables that reference a specific table. Nevertheless, the actual number of FOREIGN KEY constraints is limited by your hardware configuration and by the design of your database and application. We recommend that a table contain no more than 253 FOREIGN KEY constraints, and that it be referenced by no more than 253 FOREIGN KEY constraints. Consider the cost of enforcing FOREIGN KEY constraints when you design your database and applications.