In SQL Server Management Studio, if you are unable to modify a large database schema due to timeout error, you might need to increase the “transaction timeout” flag.
Go to tools -> Options -> Designer
and modify the “transaction timeout” flag accordingly
