Creating, modifying, removing database objects

Tables

Create table

CREATE TABLE <table-name>
    (<column name> <data type>[(<size>)],
    <column name> <data type>[(<size>)],...);

Alter table

ALTER TABLE <table name> ADD <column name>
    <data type> <size>;

Drop table

DROP TABLE <table name>;

Indexes

Create index

CREATE [UNIQUE] [CLUSTERED | NONCLUSTERED] INDEX <index_name>
ON <table_name> | <view_name> ( column [ ASC | DESC ],...)
[ON filegroup]

Rename index

ALTER INDEX <index_name>
{[RENAME TO <new_name>] |
 [REBUILD TABLESPACE <tablespace_name>]
};

Drop index

DROP INDEX <table_name>.<index_name> [,...]

Views

Create view

CREATE VIEW [[<database_name>.]<owner>.]<view_name>
     [(<column_name>,...)] [WITH {ENCRYPTION | SCHEMABINDING |
     VIEW_METADATA,...}] AS select_statement [WITH CHECK OPTION]

Alter view

ALTER VIEW [<qualifier>.]<view_name>
    [(<column_name>,...)] [WITH {ENCRYPTION | SCHEMABINDING |
    VIEW_METADATA}] AS <select_statement> [WITH CHECK OPTION]

Drop view

DROP VIEW <view_name> [,...]

Schemas

Create schema

CREATE SCHEMA AUTHORIZATION
    <owner> <create_object_statement>,...
    <grant_privilege_statement>,...

Drop schema

DROP SCHEMA <schema_name> RESTRICT