Post reply

Change the default data type in table designer?

  • December 11, 2008 at 8:32 am

    #202878

    Just recently made the move to 2005 and using SQL Server Management Studio. One thing that is driving me crazy is that when designing tables, the default data type for new fields is nchar(10). I would like to make it something else, like nvarchar for example. You would think this would be a common and easy fix, but 30 minutes of Googling turned up nothing.

    Is there a way?

  • December 11, 2008 at 9:04 am

    #911172

    try this:

    look in the registry in this path:

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\DataProject

    for this value:

    SSVDefaultColumnType

    change it from "nchar" to "varchar" or something, and see if that works for you.

    for SSVDefaultColumnType

    change it from 10 to 30 or whatever.

    look at the other keys there as well.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 11, 2008 at 9:32 am

    #911189

    Thanks Lowell! I actually wound up having to make the change in Shell as well as ShellSEM (what's the difference?) but now it is working. I appreciate the help.

    Weird that there is not an interface in studio to set those options. I hate messing with the registry. But at least it worked.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply