Generate DDL for table / view / function/ Procedure / Trigger / indexes in MySQL

Generate DDL for Table in MySQL

show create table table_name;
Example:
show create table hr.employees; 

Generate DDL for View in MySQL

SHOW CREATE VIEW view_name
Example
Show create view employee_view;

OR 
SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_SCHEMA = 'hr' AND TABLE_NAME = 'employees';

Generate DDL for Function in MySQL

SHOW CREATE FUNCTION func_name

Generate DDL for Procedure in MySQL

SHOW CREATE PROCEDURE proc_name

Generate DDL for triggers in MySQL

SHOW TRIGGERS [{FROM | IN} db_name]
 [LIKE 'pattern' | WHERE expr]
Example:
SHOW TRIGGERS LIKE 'EMP%'

OR
SELECT * FROM INFORMATION_SCHEMA.TRIGGERS
WHERE TRIGGER_SCHEMA='HR' AND TRIGGER_NAME='emp_trigger'\G

Generate DDL for indexes in MySQL

SHOW {INDEX | INDEXES | KEYS}
    {FROM | IN} tbl_name
    [{FROM | IN} db_name]
    [WHERE expr]

Example 
SHOW INDEX FROM employees;