Tag Archives: trigger

Check DDL of object present in MySQL

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

Advertisements