Results 1 to 2 of 2

Thread: Alter column

  1. #1
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Unanswered: Alter column

    what is the syntax for multiple column modifications ?

    alter table abc
    alter column x1 nvarchar(10) null

    -- works


    alter table abc
    alter column x1 nvarchar(10) null,
    alter column x2 nvarchar(10) null

    -- doesn't work or do i have to use the alter table each time ?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Want the lazy/easy way to script this?

    Make your changes in Enterprise Manager, and then before you save click the icon to script out the changes. Copy the script, cancel your changes, and paster your script in Query Analyzer for editing.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •