Check DDL of object present in MySQL
Check the DDL of Table
SHOW CREATE TABLE yourTable;
Check the DDL of View
SHOW CREATE VIEW view_name
Check DDL of Sequence
SHOW CREATE SEQUENCE sequence_name;
Check DDL of Function
SHOW CREATE FUNCTION func_name
Check DDL of Database
SHOW CREATE {DATABASE | SCHEMA} db_name
Check DDL of Package
SHOW CREATE PACKAGE [ db_name . ] package_name
SHOW CREATE PACKAGE BODY [ db_name . ] package_name
Check DDL of Procedure
SHOW CREATE PROCEDURE proc_name
Check DDL of Trigger
SHOW CREATE TRIGGER trigger_name