Results 1 to 3 of 3

Thread: alter table

  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    38

    Unanswered: alter table

    how to alter the table name?
    -- Prasad --

  2. #2
    Join Date
    Aug 2002
    Posts
    3
    rename table myschema.oldname to newname

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    To add to pcama's comment, here is what SQL Reference under the RENAME TABLE command tells tells:


    The source table must not:
    v Be referenced in any existing view definitions or summary table definitions
    v Be referenced in any triggered SQL statements in existing triggers or be the
    subject table of an existing trigger
    v Be referenced in an SQL function
    v Have any check constraints
    v Have any generated columns other than the identity column
    v Be a parent or dependent table in any referential integrity constraints
    v Be the scope of any existing reference column.


    Cheers

    Sathyaram

    Originally posted by pcama
    rename table myschema.oldname to newname

Posting Permissions

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