![]() The Tables and Columns Specifications must be set before the relationship will be valid.ĭelete the relationship selected in the Selected Relationships list. If the list is empty, no relationships have been defined for the table.Ĭreate a new relationship. Select a relationship to show its properties in the grid to the right. In the Foreign Key Relationships dialog box, you can make the following modifications. Right-click the foreign key to be modified and select Modify. ![]() In Object Explorer, expand the table with the foreign key and then expand Keys. Using SQL Server Management Studio To modify a foreign key The new foreign key column must match the data type and size of the primary key column to which it relates, with these exceptions:Ī char column or sysname column can relate to a varchar column.Ī binary column can relate to a varbinary column.Īn alias data type can relate to its base type. Modifying a table's foreign key changes which columns are related to columns in the primary key table.īefore You Begin Limitations and Restrictions You can modify the foreign key side of a relationship in SQL Server by using SQL Server Management Studio or Transact-SQL. Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |