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.
| 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 tablewhen 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 customand 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,JimEveryday I learn something that somebody else already knew |
 |
|
|
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. |
 |
|
|
nishu81
Starting Member
11 Posts |
Posted - 2009-12-30 : 01:44:19
|
| sunitaI did as u told but still I am getting same old format |
 |
|
|
divya.ce
Starting Member
16 Posts |
Posted - 2009-12-30 : 07:18:30
|
| You need to restart ssms after making the changes. |
 |
|
|
nishu81
Starting Member
11 Posts |
Posted - 2009-12-30 : 08:57:20
|
| Its working now ,Thanks a lot Divya,Sunita and JimThanks a ton |
 |
|
|
|
|
|