get schema of table mysql code example

Example 1: mysql show schema

describe [db_name.]table_name;

Example 2: mysql show schema

show create table [db_name.]table_name;