Professional Web Applications Themes

How do I set a default value once a table is built ? - IBM DB2

Hi all, According to what I can see in the doco, once a table has been created, you cannot issue an ALTER TABLE x ALTER y to set a new default value on a column. Is this correct ??? cio Derek....

  1. #1

    Default How do I set a default value once a table is built ?

    Hi all,
    According to what I can see in the doco, once a table has been created, you
    cannot issue an ALTER TABLE x ALTER y to set a new default value on a
    column.

    Is this correct ???

    cio
    Derek.
    Derek Clarkson Guest

  2. #2

    Default Re: How do I set a default value once a table is built ?

    Why not give it a try? It would only take a minute or two, which would give
    you an answer faster than waiting for a reply on the newsgroup.....

    Rhino

    "Derek Clarkson" <dclarksonwaterwerks.com.au> wrote in message
    news:3f61414fmail.netspeed.com.au...
    > Hi all,
    > According to what I can see in the doco, once a table has been created,
    you
    > cannot issue an ALTER TABLE x ALTER y to set a new default value on a
    > column.
    >
    > Is this correct ???
    >
    > cio
    > Derek.

    Rhino Guest

Similar Threads

  1. #38952 [NEW]: php cli built, libphp5.so not built
    By stevep at sga dot org in forum PHP Bugs
    Replies: 5
    Last Post: September 26th, 03:10 PM
  2. default index for primary key of a table
    By Greg Stark in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 24th, 08:15 PM
  3. Replies: 1
    Last Post: July 31st, 07:47 PM
  4. Table Default Values
    By Michael Volz in forum Microsoft Access
    Replies: 2
    Last Post: July 31st, 02:04 PM
  5. Default Value in a Table on SQL7
    By Narayana Vyas Kondreddi in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 07:49 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139