table column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: table column

  1. #1
    Hi,

    I have few questions I would like to ask. I hope somebody could help me.

    1) How to calculate each row contain how many bytes and each table contain how many bytes?

    2)Can I change column name after table being created? I think the answer is NO. Just want to make sure.

    3)How do you add new column to existing table?

    Thank you in advance.

    regards,
    feroz

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    In answer to your first question :

    http://www.dbasupport.com/forums/sho...threadid=18819

    Don't think you can rename a column

    But can use create table as.

    to add a column :

    alter table add column_definitions
    e.g alter table add (quantity number (10,3)

    have to work around to make new column NOT NULL if already has rows, post question here if unsure how.



    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    sorry to add you must specify table/schema

    e.g alter table schema.table_name add (column_definitions)
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  4. #4

    Angry

    Hi again,

    Thank you for your reply.

    regards,
    feroz

Posting Permissions

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


Click Here to Expand Forum to Full Width