1Keydata.com

SQL ALTER TABLE


  SQL > Table Manipulation > Alter Table Syntax

Once a table is created in the database, there are many occasions where one may wish to change the structure of the table. In general, the SQL syntax for ALTER TABLE is

ALTER TABLE "table_name"
[alter specification]

[alter specification] is dependent on the type of alteration we wish to perform. We list a number of common changes below:

  • ALTER TABLE Add Column

  • ALTER TABLE Modify Column

  • ALTER TABLE Rename Column

  • ALTER TABLE Drop Column

  • ALTER TABLE Add Index

  • ALTER TABLE Drop Index

  • ALTER TABLE Add Constraint

  • ALTER TABLE Drop Constraint

    • For all cases, examples are provided for MySQL, Oracle, and SQL Server.

    ALTER TABLE ADD COLUMN >>

    Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.


    More 1Keydata Tutorials
    Data Warehousing:   Data Modeling   Business Intelligence   Data Integrity   Star Schema   Logical Data Model
    CSS Tutorial:   CSS Background   CSS Border   CSS Padding   CSS Overflow   CSS Margin   CSS Cursor
    PHP Tutorial:   PHP Foreach   PHP Redirect   PHP Array   PHP Include   PHP Explode   PHP For Loop   PHP Substr
    HTML Tutorial:   Radio Button   HTML Checkbox   HTML Drop Down   Basic HTML Tags   Text Input   Color Codes


    Copyright © 2012   All Rights Reserved.     Privacy Policy  



    SQL SELECT
    SQL DISTINCT
    SQL WHERE
    SQL AND OR
    SQL IN
    SQL BETWEEN
    SQL Wildcard
    SQL LIKE
    SQL ORDER BY
    SQL Functions
    SQL Average
    SQL COUNT
    SQL MAX
    SQL MIN
    SQL SUM
    SQL GROUP BY
    SQL HAVING
    SQL ALIAS
    SQL AS
    SQL JOIN
    SQL INNER JOIN
    SQL OUTER JOIN
    SQL LEFT OUTER JOIN
    SQL CROSS JOIN
    SQL SELECT UNIQUE
    SQL CONCATENATE
    SQL SUBSTRING
    SQL TRIM
    SQL LENGTH
    SQL REPLACE
    SQL DATEADD
    SQL DATEDIFF
    SQL DATEPART
    SQL GETDATE
    SQL SYSDATE

    SQL CREATE TABLE
    SQL CONSTRAINT
    SQL NOT NULL
    SQL DEFAULT
    SQL UNIQUE
    SQL CHECK
    SQL PRIMARY KEY
    SQL FOREIGN KEY
    SQL View
    SQL CREATE VIEW
    SQL Index
    SQL CREATE INDEX
    SQL ALTER TABLE
    SQL DROP TABLE
    SQL TRUNCATE TABLE
    SQL USE
    SQL INSERT INTO
    SQL UPDATE
    SQL DELETE FROM

    SQL Jobs

    Site Map
    Resources