In MySQL you can describe tables to get their columns and types, but if you need to get the SQL that created them, you can run the following:

mysql> show create table <table_or_view_name>;