Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to change default view of the table

Author  Topic 

nishu81
Starting Member

11 Posts

Posted - 2009-12-28 : 08:52:07

There is problem I am facing while changing the default view of the create table

when we create table by default in sql server Column name , condensed type and null able comes I want to change this default design .For this

I went to Table Designer> Table view> Modify custom

and the transfer the fields from "Available columns" to "selected columns" and save as default also

but still when i am creating table I am getting old default format which consists of only "Column name" , "condensed type" and "nullable"

can anybody help me please??

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-12-28 : 10:24:40
I don't fully understand your question. What you are talking about has to do with database diagramming (Of which I know nothing), and not table creation. Could you restate your question?

Thanks,
Jim

Everyday I learn something that somebody else already knew
Go to Top of Page

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2009-12-28 : 10:42:17
You also need to go to Tools->Options in SSMS (SQL 2005) and under Designers->Table and Database Designers change the Default Table View to Custom.
Go to Top of Page

nishu81
Starting Member

11 Posts

Posted - 2009-12-30 : 01:44:19
sunita
I did as u told but still I am getting same old format
Go to Top of Page

divya.ce
Starting Member

16 Posts

Posted - 2009-12-30 : 07:18:30
You need to restart ssms after making the changes.
Go to Top of Page

nishu81
Starting Member

11 Posts

Posted - 2009-12-30 : 08:57:20
Its working now ,Thanks a lot Divya,Sunita and Jim

Thanks a ton
Go to Top of Page
   

- Advertisement -