Create a database
2005-2008r2
CREATE DATABASE MyDatabase
Create a database
2005-2008r2
CREATE DATABASE MyDatabase
Delete (drop) a database
2005-2008r2
DROP DATABASE MyDatabase
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 Address
Delete (drop) a table
2005-2008r2
DROP TABLE Person
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