Saving changes after table edit in SQL Server Management Studio

by

Go into Tools -> Options -> Designers-> Uncheck “Prevent saving changes that require table re-creation”. Voila.

That happens because sometimes it is necessary to drop and recreate a table in order to change something. This can take a while, since all data must be copied to a temp table and then re-inserted in the new table. Since SQL Server by default doesn’t trust you, you need to say “OK, I know what I’m doing, now let me do my work.”

More Related Contents:

  1. sql server 2008 management studio not checking the syntax of my query
  2. Copy tables from one database to another in SQL Server
  3. SQL Server 2008: how do I grant privileges to a username?
  4. SQL Server: drop table cascade equivalent?
  5. How do I make a composite key with SQL Server Management Studio?
  6. Logging ALL Queries on a SQL Server 2008 Express Database?
  7. Incorrect syntax near ”
  8. How to get export output in “real” CSV format in SQL Server Management Studio?
  9. The backend version is not supported to design database diagrams or tables
  10. Converting Select results into Insert script – SQL Server
  11. How to quickly edit values in table in SQL Server Management Studio?
  12. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  13. How to create a specific SQL Server stored procedure? [closed]
  14. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  15. Should I use != or for not equal in T-SQL?
  16. Conversion failed when converting date and/or time from character string while inserting datetime
  17. Foreign Key to non-primary key
  18. Difference between left join and right join in SQL Server [duplicate]
  19. Dynamic SQL – EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
  20. Get the last inserted row ID (with SQL statement) [duplicate]
  21. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  22. Run all SQL files in a directory
  23. Rename column SQL Server 2008
  24. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  25. Selecting first row per group
  26. How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?
  27. SQL Server Convert integer to binary string
  28. How to find column names for all tables in all databases in SQL Server
  29. SQL update trigger only when column is modified
  30. Export table data from one SQL Server to another

Leave a Comment