Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40

    Unanswered: changing Field Lenght via query analyzer

    Hi
    My DB is on the web so but I want change Field Lenght of one of my Fileds on my DB

    its 70 rights now I want change it to 120 its a nvarchar


    how can I do it , I am using a ASP page


    Thanks

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    ALTER TABLE tablename ALTER COLUMN columnname NVARCHAR(120)

    You can just pass this statement to the database.

    You should check out Books Online. it's free documentation that comes with SQL server.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

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