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