login

SQL Data Definition

  • CREATE TABLE Statement

    Table is a basic element of relational database and create table is very important before you are working with data which you want to store.

  • ALTER TABLE Statement

    with SQL ALTER TABLE statement you can add, drop one or more columns from a table.

  • DROP Table Statement

    DROP TABLE statement allows you drop an existing table in database which is useful in some programming situations.

  • How to Create SQL View

    SQL View is a virtual table which is used to encapsulate a complex queries.Click here to see how to create SQL view
  • SQL ALTER VIEW Statement

    SQL view is a virual table so it can be changed using ALTER VIEW statement.
  • SQL DROP VIEW Statement

    SQL DROP VIEW statement removes view definition from the system catalog and the dependent objects of that view will become invalid.
  • Creating Database Index

    A database index is similar to the book's index which helps you to find a topic faster by looking up on it.

  • SQL DROP INDEX statement

    SQL DROP INDEX statement frees allocated memory and removes the index definition from the database information schema