CREATE TABLE Statement
In this section we will show you how to create table using CREATE TABLE statement.
In this section we will show you how to create table using CREATE TABLE statement.
With SQL ALTER TABLE statement you can add, drop one or more columns from a table
SQL DROP TABLE statement allows you to drop an existing table in database.
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.
SQL view is a virual table so it can be changed by using ALTER VIEW statement.
SQL DROP VIEW statement removes view definition from the system catalog and the dependent objects of that view will become invalid.
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 frees allocated memory and removes the index definition from the database information schema.