SQL Administration Tutorial


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.

SQL > SQL Administration


SQL provides the means of administering / managing the key database objects:

The tutorial shows how to CREATE, ALTER and DROP as appropriate each of the major relational database objects.

SQL Objects and Operations

SQL ObjectCREATEALTERDROP
SQL DATABASE SQL CREATE DATABASE
---
SQL DROP DATABASE
SQL TABLE SQL CREATE TABLE SQL ALTER TABLE SQL DROP TABLE
SQL INDEX SQL CREATE INDEX
---
SQL DROP INDEX
SQL FOREIGN KEY SQL ADD FOREIGN KEY
---
SQL DROP FOREIGN KEY
SQL VIEW SQL CREATE VIEW
---
SQL DROP VIEW

HOME | OVERVIEW | BASICS | ADMINISTRATION | ADVANCED | SYNTAX | Bookmark and Share
infogoal.com HOME
SQL OVERVIEW
SQL SYNTAX
SQL BOOKREVIEWS
SQL BASICS
SELECT
WHERE
INSERT
UPDATE
DELETE
SQL ADMINISTRATION
CREATE DATABASE
DROP DATABASE
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
DROP INDEX
ADD FOREIGN KEY
DROP FOREIGN KEY
CREATE VIEW
DROP VIEW
SQL ADVANCED
CONCAT
SUBSTRING
TRIM
AND & OR
IN
BETWEEN
LIKE
DISTINCT
GROUP BY
AGGREGATE
HAVING
ORDER BY
JOIN
OUTER JOIN
Copyright© 1999-2015, First Place Software, Inc.