this is from the Help About
Microsoft SQL Server Management Studio 12.0.2269.0
Microsoft Analysis Services Client Tools 12.0.2000.8
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.18283
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.9600
---------
I had a table called Mydata which had 1 column [Name]. since it had data I renamed it to Mydata-old.
I recreated a new table called Mydata with [Name], [RecordID] and [DateCreated].
then I pressed F5 to see the new table in the Object Explorer. it shows up with the new fields. next I right clicked the new Mydata table and choose 'Script Table as' > 'Insert to' > 'New Query Editor Window'
However I does not have the new columns, it just had the original column {name] and does not have [RecordID] and [DateCreated].
Is there a way to refresh the Object Explorer or whatever is the problem without having to completely close SSMS and then reopen it? making changes to items and then hacing to close SSMS each time is major drawback.
this happens with intelli-sense as well. it does not see the new changes either. if a table has a new column it puts red squiggly saying invalid column it does however run Ok. but having a smart IDE is no good if it can't see new things without a reload.
TIA
DougP
Microsoft SQL Server Management Studio 12.0.2269.0
Microsoft Analysis Services Client Tools 12.0.2000.8
Microsoft Data Access Components (MDAC) 6.3.9600.17415
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.9600.18283
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.9600
---------
I had a table called Mydata which had 1 column [Name]. since it had data I renamed it to Mydata-old.
I recreated a new table called Mydata with [Name], [RecordID] and [DateCreated].
then I pressed F5 to see the new table in the Object Explorer. it shows up with the new fields. next I right clicked the new Mydata table and choose 'Script Table as' > 'Insert to' > 'New Query Editor Window'
However I does not have the new columns, it just had the original column {name] and does not have [RecordID] and [DateCreated].
Is there a way to refresh the Object Explorer or whatever is the problem without having to completely close SSMS and then reopen it? making changes to items and then hacing to close SSMS each time is major drawback.
this happens with intelli-sense as well. it does not see the new changes either. if a table has a new column it puts red squiggly saying invalid column it does however run Ok. but having a smart IDE is no good if it can't see new things without a reload.
TIA
DougP