Chapter 13 SQL Statements Table of Contents 13.1 Data Definition Statements .................................................................................................... 2464 13.1.1 Atomic Data Definition Statement Support ................................................................... 2464 13.1.2 ALTER DATABASE Statement ................................................................................... 2470 13.1.3 ALTER EVENT Statement .......................................................................................... 2475 13.1.4 ALTER FUNCTION Statement .................................................................................... 2477 13.1.5 ALTER INSTANCE Statement .................................................................................... 2477 13.1.6 ALTER LOGFILE GROUP Statement .......................................................................... 2479 13.1.7 ALTER PROCEDURE Statement ................................................................................ 2481 13.1.8 ALTER SERVER Statement ........................................................................................ 2481 13.1.9 ALTER TABLE Statement ........................................................................................... 2481 13.1.10 ALTER TABLESPACE Statement .............................................................................. 2505 13.1.11 ALTER VIEW Statement ........................................................................................... 2507 13.1.12 CREATE DATABASE Statement ............................................................................... 2507 13.1.13 CREATE EVENT Statement ...................................................................................... 2508 13.1.14 CREATE FUNCTION Statement ............................................................................... 2513 13.1.15 CREATE INDEX Statement ...................................................................................... 2513 13.1.16 CREATE LOGFILE GROUP Statement ..................................................................... 2528 13.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements ................................... 2530 13.1.18 CREATE SERVER Statement ................................................................................... 2535 13.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement ............................................... 2536 13.1.20 CREATE TABLE Statement ...................................................................................... 2541 13.1.21 CREATE TABLESPACE Statement ........................................................................... 2597 13.1.22 CREATE TRIGGER Statement ................................................................................. 2604 13.1.23 CREATE VIEW Statement ........................................................................................ 2606 13.1.24 DROP DATABASE Statement ................................................................................... 2610 13.1.25 DROP EVENT Statement ......................................................................................... 2611 13.1.26 DROP FUNCTION Statement ................................................................................... 2611 13.1.27 DROP INDEX Statement .......................................................................................... 2612 13.1.28 DROP LOGFILE GROUP Statement ......................................................................... 2612 13.1.29 DROP PROCEDURE and DROP FUNCTION Statements .......................................... 2613 13.1.30 DROP SERVER Statement ....................................................................................... 2613 13.1.31 DROP SPATIAL REFERENCE SYSTEM Statement ................................................... 2613 13.1.32 DROP TABLE Statement .......................................................................................... 2614 13.1.33 DROP TABLESPACE Statement ............................................................................... 2615 13.1.34 DROP TRIGGER Statement ..................................................................................... 2616 13.1.35 DROP VIEW Statement ............................................................................................ 2616 13.1.36 RENAME TABLE Statement ..................................................................................... 2617 13.1.37 TRUNCATE TABLE Statement ................................................................................. 2619 13.2 Data Manipulation Statements ............................................................................................... 2620 13.2.1 CALL Statement ......................................................................................................... 2620 13.2.2 DELETE Statement .................................................................................................... 2621 13.2.3 DO Statement ............................................................................................................ 2625 13.2.4 HANDLER Statement ................................................................................................. 2626 13.2.5 IMPORT TABLE Statement ........................................................................................ 2628 13.2.6 INSERT Statement ..................................................................................................... 2630 13.2.7 LOAD DATA Statement .............................................................................................. 2639 13.2.8 LOAD XML Statement ................................................................................................ 2651 2463