Post reply

Change field Length in Enterprise Manager

  • January 10, 2007 at 12:04 pm

    #69380

    Where do i go to actually change the field length of an existing field in SQL Enterpise manager?

  • January 10, 2007 at 12:34 pm

    #682527

    Click the database, Tables -> right click on the table you want to modify,

    Select design.

    Go to desired field change the length value.

    Click save.

     

  • January 10, 2007 at 12:36 pm

    #682530

    in enterprise manager, expand the views and drill in till you see the table that contains the column you wish to change.

    right click on the table>>Choose "Design Table"

    A list of columns for the table appears. the second column is the data type, and the third column is the defined size.

    change the value of the appropriate column and click the save icon. you may be warned that other tables may be affected due to foreign key contraints, but that is OK; you already stated you know you want to change the column , so go for it.

    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!

  • January 10, 2007 at 12:36 pm

    #682528

    Thanks Ray

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

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