Quick Reference: Basic SQL Statements


ABORT	GIVE
ALTER PROCEDURE	GRANT
ALTER TABLE	GRANT LOGON
ALTER TRIGGER	GRANT MONITOR
	GRANT ROLENAME
BEGIN LOGGING
BEGIN TRANSACTION	INSERT

CALL	LOGOFF
CHECKPOINT	LOGON
COLLECT STATISTICS
COMMENT ON	MODIFY DATABASE
COMMIT	MODIFY PROFILE
CREATE DATABASE	MODIFY USER
CREATE HASH INDEX
CREATE INDEX	RENAME
CREATE JOIN INDEX	REPLACE MACRO
CREATE MACRO	REPLACE PROCEDURE
CREATE PROCEDURE	REPLACE TRIGGER
CREATE PROFILE	REPLACE VIEW
CREATE ROLE	REVOKE
CREATE TABLE	REVOKE LOGON
CREATE TABLE ... AS	REVOKE ROLE
CREATE TRIGGER	ROLLBACK
CREATE USER
CREATE VIEW	SELECT
	SET TIME ZONE
DATABASE	SET ROLE
DELETE	SET SESSION
DELETE DATABASE / USER	SET TIME ZONE
DROP
DROP INDEX	UPDATE
DROP STATISTICS	UPDATE/INSERT

ECHO
END LOGGING
END TRANSACTION
EXECUTE

Copyright for the TeradataForum (TDATA-L), Manta BlueSky

Copyright 2012 - All Rights Reserved

Last Modified: 21 Mar 2013