Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    SQL Cheat Sheet Createtable Alter Drop Truncate

    Uploaded by

    Mahmoud Abdulhamid

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    SQL Cheat Sheet Createtable Alter Drop Truncate

    Uploaded by

    Mahmoud Abdulhamid
    10 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    10 views1 page

    SQL Cheat Sheet Createtable Alter Drop Truncate

    Uploaded by

    Mahmoud Abdulhamid

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    11/10/23, 10:37 AM about:blank

    SQL Cheat Sheet: CREATE TABLE, ALTER, DROP, TRUNCATE


    Command Syntax Description Example
    CREATE TABLE table_name (col1 datatype CREATE TABLE statement is to create the table.
    CREATE TABLE employee ( employee_id char(2)
    CREATE optional keyword, col2 datatype optional Each column in the table is specified with its PRIMARY KEY, first_name varchar(30) NOT
    TABLE keyword,col3 datatype optional keyword,..., name, data type and an optional keyword which
    NULL, mobile int);
    coln datatype optional keyword) could be PRIMARY KEY, NOT NULL, etc.,
    ALTER ALTER TABLE table_name ADD COLUMN
    ALTER TABLE statement is used to add the ALTER TABLE employee ADD COLUMN income
    TABLE - ADD column_name_1 datatype....ADD COLUMN
    column_name_n datatype; columns to a table. bigint;
    COLUMN
    ALTER
    TABLE - ALTER TABLE table_name ALTER COLUMN ALTER TABLE ALTER COLUMN statement is used to ALTER TABLE employee ALTER COLUMN mobile
    ALTER column_name_1 SET DATA TYPE datatype; modify the data type of columns. SET DATA TYPE CHAR(20);
    COLUMN
    ALTER
    TABLE - ALTER TABLE table_name DROP COLUMN ALTER TABLE DROP COLUMN statement is used to
    ALTER TABLE employee DROP COLUMN mobile ;
    DROP column_name_1 ; remove columns from a table.
    COLUMN
    ALTER
    TABLE - ALTER TABLE table_name RENAME COLUMN ALTER TABLE RENAME COLUMN statement is used to ALTER TABLE employee RENAME COLUMN
    RENAME current_column_name TO new_column_name; rename the columns in a table. first_name TO name ;
    COLUMN
    TRUNCATE TABLE statement is used to delete all of
    TRUNCATE the rows in a table. The IMMEDIATE specifies
    TRUNCATE TABLE table_name IMMEDIATE; TRUNCATE TABLE employee IMMEDIATE ;
    TABLE to process the statement immediately and that it
    cannot be undone.
    Use the DROP TABLE statement to delete a table
    from a database. If you delete a table that
    DROP TABLE DROP TABLE table_name ; DROP TABLE employee ;
    contains data, by default the data will be deleted
    alongside the table.

    Author(s)
    Himanshu Birla

    Changelog
    Date Version Changed by Change Description
    2023-05-04 1.1 Benny Li Formatting changes made
    2021-07-27 1.0 Himanshu Birla Initial Version

    about:blank 1/1

    You might also like