Scribd Logo
Upload

Welcome to Scribd!

  • 64 views

    Data Definition Language (DDL)

    Uploaded by

    Kapil Pokhrel
    This document discusses Data Definition Language (DDL) queries in SQL. It defines DDL as SQL commands that define the database schema and structure, allowing users to add, alter, and delete logical structures like databases, tables, keys, and views. The document provides examples of DDL commands like CREATE, ALTER, and DROP and how to create databases and tables, add/modify/delete columns, rename tables, and delete tables and databases. It also lists MySQL data types and provides a link to the documentation for more details on each type.

    Copyright:

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

    Data Definition Language (DDL)

    Uploaded by

    Kapil Pokhrel
    64 views5 pages
    This document discusses Data Definition Language (DDL) queries in SQL. It defines DDL as SQL commands that define the database schema and structure, allowing users to add, alter, and delete logical structures like databases, tables, keys, and views. The document provides examples of DDL commands like CREATE, ALTER, and DROP and how to create databases and tables, add/modify/delete columns, rename tables, and delete tables and databases. It also lists MySQL data types and provides a link to the documentation for more details on each type.

    Original Title

    SQL-LAB_2_DDL

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses Data Definition Language (DDL) queries in SQL. It defines DDL as SQL commands that define the database schema and structure, allowing users to add, alter, and delete logical structures like databases, tables, keys, and views. The document provides examples of DDL commands like CREATE, ALTER, and DROP and how to create databases and tables, add/modify/delete columns, rename tables, and delete tables and databases. It also lists MySQL data types and provides a link to the documentation for more details on each type.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    64 views5 pages

    Data Definition Language (DDL)

    Uploaded by

    Kapil Pokhrel
    This document discusses Data Definition Language (DDL) queries in SQL. It defines DDL as SQL commands that define the database schema and structure, allowing users to add, alter, and delete logical structures like databases, tables, keys, and views. The document provides examples of DDL commands like CREATE, ALTER, and DROP and how to create databases and tables, add/modify/delete columns, rename tables, and delete tables and databases. It also lists MySQL data types and provides a link to the documentation for more details on each type.

    Copyright:

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

    2.

    DDL queries
    Instructor: Bidur Devkota
    13th Sept 2020

    Data Definition Language (DDL)


    • includes SQL commands that define the database schema. i.e. about "metadata".
    • DDL works to add / alter / delete the logical structures that contain the data
    • DDL allows to access / maintain the data (databases, tables, keys, views...).
    • E.g. CREATE, ALTER and DROP statements.

    Data types:
    MySQL supports SQL data types in several categories: numeric types, date and
    time types, string (character and byte) types, spatial types,etc. More details are
    available in the MySQL documentation.
    https://dev.mysql.com/doc/refman/5.7/en/data-types.html

    1
    1. Create Database

    Syntax:
    CREATE DATABASE <DatabaseName>

    Example:

    CREATE DATABASE infomax;

    USE infomax;

    2. Create Table
    Syntax:
    CREATE TABLE <TableName> (
    <Column1> <DataType>,
    <Column2> <DataType>,
    .
    .
    .
    <ColumnN> <DataType>,
    )

    Example:

    CREATE TABLE students (


    roll INT,
    name VARCHAR(50),
    phone INT,
    sem VARCHAR(20)
    );

    3. ALTER Table

    To modify the tables to add, rename, edit or delete a column .

    3.1 ADD Column


    Syntax:
    ALTER TABLE <TableName> ADD <ColumnName> <DataType>

    ALTER TABLE students ADD department VARCHAR(20);

    desc students;

    2
    3.2. Modify column name and datatype
    Syntax:
    ALTER TABLE <TableName> RENAME TO <NewTableName> <DataType>

    ALTER TABLE students CHANGE sem TO semester INT;

    Modify Datatype only


    Syntax:
    ALTER TABLE <TableName> MODIFY <ColumnName> <DataType>

    ALTER TABLE students MODIFY semester VARCHAR(20);

    3.3 Rename table

    Syntax:

    ALTER TABLE <TableName> RENAME TO <NewTableName>

    ALTER TABLE students RENAME TO infomax_students;

    3
    3.4 Delete column
    Syntax:
    ALTER TABLE <TableName> DROP COLUMN <ColumnName>;

    ALTER TABLE students DROP COLUMN phone;

    4. Delete
    table

    Syntax:
    DROP TABLE <TableName>

    DROP TABLE students;

    4
    5. Delete Database

    Syntax:
    DROP DATABASE <DatabaseName>

    DROP DATABASE infomax;

    Task:

    1. Complete the above examples.


    Instead of the table name student create new table with name `your-
    name_roll`.
    For e.g. if your name is Ram and your roll number is 100 then you have to create
    table named `ram-100`.

    Submission:
    1. Title: 2. DDL Queries.
    2. Theory: Explain about the related queries( syntax, Descriptions)
    3. Observations: Queries you run and their screenshot.
    4. Conclusion

    Note:
    1. Submit a file with name <2_DDL_Queries_ROLL_NAME.pdf>
    For example student ‘Ram’ with roll number ‘100’ should send a file named:
    2_DDL_Queries_100_Ram.pdf
    2. Copying will be marked ZERO.
    3. Send as email attachment to [email protected]
    4. Email Subject: 2. DDL Queries

    You might also like