DML Statements in Teradata


SELECT
SELECT column1, column2 FROM table


INSERT
INSERT INTO table (column1, column2)
VALUES ('value1','value 2')

UPDATE
UPDATE table SET column2 = 'value 3' WHERE column1 = 'value1'


DELETE
 DELETE <databasename>
 DELETE <username>
 DELETE FROM <TABLENAME>