a
 
SQLRef.Com 

            SqlRef.Com


SQL BASIC
DATA QUERY LANGUAGE
BASIC FUNCTION
AGGREGATE FUNCTION
DATA MANIPULATION LANGUAGE
DATA DEFINITION LANGUAGE
DATA CONTROL LANGUAGE
OTHERS

SQL Command

Structured Query Language (SQL) has a set of commands that can be used to manipulate relational database. The commands can be categorized into data definition function, data manipulation function and data control function. SQL Commands usually appear in the form of action verb. It is a basic convention that all SQL statements begin with a command. The following table list the core SQL commands.

ALTER DOMAIN DECLARE CURSOR FETCH
ALTER TABLE DECLARE TABLE FREE LOCATOR
CALL DELETE GET DIAGNOSTICS
CLOSE DISCONNECT GRANT
COMMIT DROP ASSERTION HOLD LOCATOR
CONNECT DROP CHARACTER SET INSERT
CREATE ASSERTION DROP COLLATION OPEN
CREATE CHARACTER SET DROP DOMAIN RELEASE SAVEPOINT
CREATE COLLATION DROP ORDERING RETURN
CREATE DOMAIN DROP ROLE REVOKE
CREATE FUNCTION DROP SCHEMA ROLLBACK
CREATE METHOD DROP SPECIFIC FUNCTION SAVEPOINT
CREATE ORDERING DROP SPECIFIC PROCEDURE SELECT
CREATE PROCEDURE DROP SPECIFIC ROUTINE SET CONNECTION
CREATE ROLE DROP TABLE SET CONSTRAINTS
CREATE SCHEMA DROPT TRANSFORM SET ROLE
CREATE TABLE DROP TRANSLATION SET SESSION AUTHORIZATION
CREATE TRANSFORM DROP TRIGGER SET CHARACTERISTICS
CREATE TRANSLATION DROP TYPE SET TIME ZONE
CREATE TRIGGER DROP VIEW SET TRANSACTION
CREATE TYPE   START TRANSACTION
CREATE VIEW   UPDATE



 
| Freebies | Free Trial | Add to Bookmark | Search | Link to Us |
Copyright © 2006 SqlRef.com. All rights reserved.