April 11, 2017 at 9:36 am
Is there a concise reference that lists the data modifications which would cause SQL server to recreate a table? For instance, I think if you add columns to the end of a table, it will not be recreated, but I believe if you add a column anywhere else SQL will drop and recreate the table.
I believe also changing certain data types, but I can't find any documentation on that.
Thanks!
Nick
April 11, 2017 at 9:44 am
Nick
I'm not sure such a reference exists. My advice is to use T-SQL commands instead of the GUI, and then you know exactly what's going to happen, and you don't get caught out by ostensibly simple operations taking time and chewing up resources.
John
April 12, 2017 at 8:28 am
SQL Server, or Management Studio?
SQL Server will not recreate a table. The closest would be changing the clustered index.
As for Management Studio, easiest answer there is not to use the GUI, or if you must, script out the modification rather than just running it and see what SSMS wants to do.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2017 at 6:06 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply