first steps

display criteria

aggregation functions

operations on strings

operations on tables

• ALTER
• CHECK
• CREATE INDEX
• CREATE TABLE
• CREATE VIEW
• DEFAULT
• DROP
• FOREIGN KEY
• NOT NULL
• PRIMARY KEY
• UNIQUE

all keywords

Test yourself - QUIZ

Theory

Basics

• database models
• Codd's 12 rules
• keys
• relationships
• dependencies
• ERD diagrams
• transactions

Normalization

• 1st normal form
• 2nd normal form
• 3rd normal form
• Boyce-Codd normal form

PL/pgSQL language

• introduction
• conditional instructions
• loops
• functions

you are at Encyclopedia of SQL >> DROP

DROP

With DROP we are able to remove indexes, tables, databases

Syntax for removing index from table

MySQL
ALTER TABLE `table_name`
DROP INDEX index_name

MS Access
DROP INDEX index_name
ON `table_name`

MS SQL Server
DROP INDEX `table_name`.index_name

DB2/Oracle
DROP INDEX index_name

Syntax for removing table

DROP TABLE `table_name`

Syntax for deleting database

DROP DATABASE `database_name`

Example

Delete `people` table

query

DROP TABLE `people`

[ wróć na górę strony ]