Home Page for the TeradataForum
 

 

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  





 
  Top Home Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2016 - All Rights Reserved
Last Modified: 28 Dec 2016