SSMS 2014 Design Does not show column

Asked Dec 06 '16 at 10:37

Active Dec 06 '16 at 10:57

Viewed 121 times

I have created a table which has the columns

Id, name, CountryId,CreatedOn,CreatedBy,updatedOn,UpdatedBy

but when i see the design, there is no CountryId.

When i see script of the created table, it shows CountryId

the script is as follows --

   CREATE TABLE [dbo].[State](
        [Id] [int] NOT NULL,
        [name] [nvarchar](255) NOT NULL,
        [CountryId] [int] NOT NULL,
        [CreatedOn] [datetime] NULL,
        [CreatedBy] [nvarchar](50) NULL,
        [UpdatedOn] [datetime] NULL,
        [UpdatedBy] [nvarchar](50) NULL,
    );

Also, When I right click and select top 100 rows, i find CountryId there. (The following image)

What can be the reason that the design is not showing a column ??

EDIT: As suggested by shnugo, i was able to solve it after closing and re-opening SSMS 2014

edited May 23 '17 at 12:01

Community

asked Dec 06 '16 at 10:37

Dastagir Husain Yasin

Try re-opening the DESIGN view. I couldn't reproduce the issue and I used the code you provided. I'm also using SSMS 2014, version 12.0.2000.8 to be precise. – Radu Gheorghiu Dec 06 '16 at 10:39
Did you try to right-click onto the `dbo,State` node of the tree view and refresh it? – Shnugo Dec 06 '16 at 10:43
yes, I tried refreshing the Db, but no luck @Shnugo – Dastagir Husain Yasin Dec 06 '16 at 10:50
re-opening did not work @RaduGheorghiu – Dastagir Husain Yasin Dec 06 '16 at 10:50
Shut down SSMS and re-open it? – Shnugo Dec 06 '16 at 10:50
I'm not sure you're going to get a clear answer and precise here, since the issue you're experiencing is not a general one and not one which can be reproduced easily (or in normal circumstances). And what we're doing now is just doing "caveman debugging" in terms of suggestions. – Radu Gheorghiu Dec 06 '16 at 10:52
@Shnugo , awsome !! it worked after re-opening the SSMS :) – Dastagir Husain Yasin Dec 06 '16 at 10:52
But what can be the reason which eliminated after re-opening the SSMS ? – Dastagir Husain Yasin Dec 06 '16 at 10:53
1

@Shnugo suggested you to refresh the table, while you were trying to "refresh the db" - these are different object tree levels. – Ivan Starostin Dec 06 '16 at 10:55
I refreshed the `Table` as suggested, but It did not work. – Dastagir Husain Yasin Dec 06 '16 at 10:57
@DastagirHusainYasin why don't you upgrade to the *latest* version? SSMS is a separate product now, which can be downloaded for free. The latest version [came out today](https://msdn.microsoft.com/en-us/library/mt238290.aspx) – Panagiotis Kanavos Dec 06 '16 at 11:01
@PanagiotisKanavos , Thanks for the suggestion, I have downloaded it . – Dastagir Husain Yasin Dec 07 '16 at 03:09

SSMS 2014 Design Does not show column

0 Answers0