info management 06

Query

is a specific request for data manipulation

Popular Database Management Tools

*Microsoft SQL server
*MySQL
*Oracle RDBMS
*Microsoft Access

Exact numeric

bigint, bit, decimal, int, money, numeric

Approximate numeric

float, real

Date and Time

Date, DateTime, Time

Character Strings

char, text, varchar

Unicode character strings

nchar, ntext, nvarchar

Binary Strings

Binary, Image, varbinary

Other data types

cursor, sql_variant, table, uniqueidentifier, xml

Arithmetic

+,-,*,/,%

Comparison

=,>,<,>=,<=,<>

Logical

AND, OR, NOT, LIKE, IN, BETWEEN, EXIST, ANY, ALL

CREATE DATABASE

create a new database

DROP DATABASE

delete an existing database

CREATE TABLE

create a new table in a database

DROP TABLE

deletes an existing table in a database

ALTER TABLE

adds, delete, or modifies columns in an existing table

NOT NULL on CREATE TABLE

ensures that a column cannot have a null value upon creating table

NOT NULL on ALTER TABLE

ensures that a column in an existing table cannot have a null value

UNIQUE ON CREATE TABLE

ensures that all values in a column are different upon creating table

UNIQUE ON ALTER TABLE

creates a unique constraint on a column of an existing table

PRIMARY KEY ON CREATE TABLE

uniquely identifies each row in table

PRIMARY KEY on ALTER TABLE

creates a primary key constraint on a column of an existing table

FOREIGN KEY on CREATE TABLE

uniquely identifies a row in another table

FOREIGN KEY on ALTER TABLE

creates a foreign key constraint on a column of an existing table

CHECK on CREATING TABLE

ensures that all values in column satisfy a specific condition upon creating a table

CHECKING on ALTER TABLE

ensures that all values in a column of an existing table satisfy a specification condition

DEFAULT on CREATING TABLE

sets a default value for a column where there is no value specified

DEFAULT on ALTER TABLE

sets a default value for a column of an existing table when there is no value specified