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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.