How can I change properties of FK in SQL Server database project?
Arseni Mourzenko
When working on an SQL Server database project in Visual Studio 2012, I'm encountering a strange issue. While I can easily modify the properties of a table, column or primary key, the Properties fields other than "(Name)" are disabled for foreign keys.
Why? Is there something I can do to be able to edit foreign keys directly through the Properties tab, or modifying them through the T-SQL pane is the only way?
Karunish
Try this cheat.
Open the corresponding table out of VS using a notepad and change the table.sql file permissions from read only to editable. After this, update the foreign key and save table.sql file.
이제 다시 한 번 VS 테이블 디자이너에서 테이블을 열면 작동합니다. 파일을 tfs에 연결 한 경우 파일에 대한 더미 체크 아웃 및 체크인을 수행하여 TFS에서도 최신 파일을 사용할 수 있는지 확인할 수 있습니다.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
- 이전 게시물：Tmux: Prompt to select window for join-pane while still seeing window numbers and titles?
- 다음 포스트：VPN은 실제로 어떤 용도로 사용됩니까?
관련 기사
Related 관련 기사
- 1
how can we change the date format of SQL Server(2008) Database?
- 2
How can I access a SQL Server database with . in name via set-location
- 3
Change LogOn properties of a SQL server instance
- 4
How can I make large IN clauses more efficient in SQL Server?
- 5
In SQL Server, how can I compare a part of a string?
- 6
How can I start using MS-SQL Server ( express )
- 7
How can I back up a stored procedure in SQL Server?
- 8
SQL Server : How can I enable/reconfigure xp_cmdshell through a linked server
- 9
How to import huge blob into SQL Server database?
- 10
How to change the name of table in SQL Server that is a keyword
- 11
How can I use a Maven project as a dependency to another Maven project?
- 12
How can I do this as 1 database query?
- 13
열이 PK 및 FK 둘 다인 SQL Server
- 14
FK 제약 조건 WITH CHECK 추가 (SQL Server)
- 15
How can I import existing local tatuk shape to ms sql server
- 16
How can I insert a record retrieved from an ms access table into an sql server table?
- 17
How can I use a CASE condition based on a junction table in SQL Server?
- 18
How can I change the prompt of the terminal permanently
- 19
How can I change the default gateway?
- 20
How can I change button value with stylish?
- 21
Docky - how can I change jDownloader icon?
- 22
How can i change hyperlink color with JQuery?
- 23
How can I change the default Nautilus Bookmarks?
- 24
How can I change the colors of the slices of the pie?
- 25
How can I run a script on resolution change?
- 26
Can I change how file completion is displayed?
- 27
How can I change the system font?
- 28
How can I write the code to get all the properties of a class?
- 29
How can I have a TextBox style with properties of other TextBox style
몇 마디 만하겠습니다