I have a situation where a number of foreign keys are referencing a column in Table "A". I would like to change the length of the column in table "A". What is the best way to accomplish this in SQL Server 2008 R2? I am really hoping I don't have to drop all 30 foreign key constraints and re-create them again…
Sql-server – Changing field length when foreign keys reference primary key field in table
sql serversql-server-2008
Related Question
- Sql-server – size of a primary key and foreign key
- Sql-server – deleting a table referenced by many foreign keys
- Sql-server – Cascade primary key update to all referencing foreign keys
- Sql-server – Maximizing Availability on a Table When Changing Data Type
- Sql-server – How to change VARCHAR length in PRIMARY KEY in SQL Server 2014
- Sql-server – Composite Primary Key on partitioned tables, and Foreign Keys
- Sql-server – 2 tables with foreign keys to 3rd table with primary key
Best Answer