CREATE TABLE Statement
In this section we will show you how to create table using CREATE TABLE statement.
SQL Data Definition
SQL ALTER TABLE Statement
With SQL ALTER TABLE statement you can add, drop one or more columns from a table
DROP TABLE Statement
SQL DROP TABLE statement allows you to drop an existing table in database.
How to Create SQL View
SQL View is a virtual table which is used to encapsulate a complex queries. After creating SQL view, you can treat it as a table and manipulate data on it with only some restrictions.
Using ALTER VIEW Statement
SQL view is a virual table so it can be changed by 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 help you find a topics faster by looking up on it. Here you can learn how to create database index.
SQL DROP INDEX Statement
SQL DROP INDEX statement frees allocated memory and removes the index definition from the database information schema.