Created attachment 109233 [details]
auto completion doesn't show for example "CREATE"

We need to have full set of DDL for auto-complete for mySQL.

Currently we auto-complete support for Table and record level.

Here are a list of Data Definition Statements:

12.1.1. ALTER DATABASE Syntax
12.1.2. ALTER EVENT Syntax
12.1.3. ALTER LOGFILE GROUP Syntax
12.1.4. ALTER FUNCTION Syntax
12.1.5. ALTER PROCEDURE Syntax
12.1.6. ALTER SERVER Syntax
12.1.7. ALTER TABLE Syntax
12.1.8. ALTER TABLESPACE Syntax
12.1.9. ALTER VIEW Syntax
12.1.10. CREATE DATABASE Syntax
12.1.11. CREATE EVENT Syntax
12.1.12. The CREATE FUNCTION Statement
12.1.13. CREATE INDEX Syntax
12.1.14. CREATE LOGFILE GROUP Syntax
12.1.15. CREATE PROCEDURE and CREATE FUNCTION Syntax
12.1.16. CREATE SERVER Syntax
12.1.17. CREATE TABLE Syntax
12.1.18. CREATE TABLESPACE Syntax
12.1.19. CREATE TRIGGER Syntax
12.1.20. CREATE VIEW Syntax
12.1.21. DROP DATABASE Syntax
12.1.22. DROP EVENT Syntax
12.1.23. DROP FUNCTION Syntax
12.1.24. DROP INDEX Syntax
12.1.25. DROP LOGFILE GROUP Syntax
12.1.26. DROP PROCEDURE and DROP FUNCTION Syntax
12.1.27. DROP SERVER Syntax
12.1.28. DROP TABLE Syntax
12.1.29. DROP TABLESPACE Syntax
12.1.30. DROP TRIGGER Syntax
12.1.31. DROP VIEW Syntax
12.1.32. RENAME DATABASE Syntax
12.1.33. RENAME TABLE Syntax
12.1.34. TRUNCATE TABLE Syntax 

The number refers the MySQL 5.1 Reference Manual