在View Designer中具有FK关系的SQL Server Management Studio中的错误 [英] Bug In SQL Server Management Studio with FK relations in View Designer

问题描述

适用于：SQL Server Management Studio  v17.9.1和v.17.6以及旧版本。

在视图设计器的图表窗格中使用主键"Id"添加两个表时，在两个Id字段之间添加了错误的JOIN，而这些表之间没有外键关系。

解决方案

适用于：SQL Server Management Studio  v17.9.1和v.17.6以及旧版本。

在视图设计器的图表窗格中使用主键"Id"添加两个表时，在两个Id字段之间添加了错误的JOIN，而这些表之间没有外键关系表。

如果您认为自己发现了错误，请在正确的位置报告： - ）

https://docs.microsoft.com/en-us/sql/sql-server/sql-server-get-help?vi ew = sql-server-2017 #i-want-to-make-a-suggestion-about-sql-server-management-studio

特别是对于SSMS，你可以使用这个直接链接：

https://feedback.azure.com/forums/908035 -sql-server

*不要忘记添加图片以阐明您的意思和所看到的内容。它还可以帮助我们在论坛中更好地理解

的问题

Applies to: SQL Server Management Studio v17.9.1 and v.17.6 and also older versions.

When adding two tables in the diagram pane of the view designer with primary key 'Id' , a wrong JOIN is added between both Id fields while there is no foreign key relation between these tables.

解决方案

Applies to: SQL Server Management Studio v17.9.1 and v.17.6 and also older versions.

When adding two tables in the diagram pane of the view designer with primary key 'Id' , a wrong JOIN is added between both Id fields while there is no foreign key relation between these tables.

If you think that you found a bug then please report it in the right place :-)

https://docs.microsoft.com/en-us/sql/sql-server/sql-server-get-help?view=sql-server-2017#i-want-to-make-a-suggestion-about-sql-server-management-studio

Specifically for SSMS you can use this direct link:
https://feedback.azure.com/forums/908035-sql-server

* Don't forget to add image to clarify what you mean and what you see. It could also help us in the forum to better understand the issue

这篇关于在View Designer中具有FK关系的SQL Server Management Studio中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！