Create a database
2005-2008r2
CREATE DATABASE MyDatabaseDatabase Manipulation
- CREATE DATABASE database_name
- DROP DATABASE database_name
Delete (drop) a database
2005-2008r2
DROP DATABASE MyDatabaseTable Manipulation
-
CREATE TABLE table_name
(
column_name column_datatype
[,... column_name column_datatype ]
) -
ALTER TABLE table_name
ADD column_name column_datatype -
ALTER TABLE table_name
DROP COLUMN column_name - DROP TABLE table_name
Create a table
2005-2008r2
CREATE TABLE Person
(
LastName varchar(50),
FirstName varchar(50),
Age int
)Add columns to an existing table
2005-2008r2
ALTER TABLE Person
ADD Address varchar(160)Delete (drop) columns from an existing table
2005-2008r2
ALTER TABLE Person
DROP COLUMN AddressDelete (drop) a table
2005-2008r2
DROP TABLE PersonIndex Manipulation
-
CREATE INDEX index_name ON table_name
(
column_name [,... column_name ]
) -
CREATE UNIQUE INDEX index_name ON table_name
(
column_name [,... column_name ]
) - DROP INDEX index_name ON table_name
Create a simple index
2005-2008r2
CREATE INDEX PersonIndex ON Person
(
LastName
)Create a unique index
2005-2008r2
CREATE UNIQUE INDEX PersonIndex ON Person
(
LastName
)Delete (drop) an index
2005-2008r2
DROP INDEX PersonIndex ON Person