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:

  • Add Column

  • Modify Column

  • Rename Column

  • Drop Column

  • Add Index

  • Drop Index

  • Add Constraint

  • Drop Constraint

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

    Next: SQL ADD COLUMN



    Copyright © 2013 1keydata.com   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 ROUND
    SQL CAST
    SQL CONVERT
    SQL CONCATENATE
    SQL SUBSTRING
    SQL INSTR
    SQL TRIM
    SQL LENGTH
    SQL REPLACE
    SQL DATEADD
    SQL DATEDIFF
    SQL DATEPART
    SQL GETDATE
    SQL SYSDATE

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

    SQL Video Tutorial
    SQL Jobs

    Site Map
    Resources