sp_help for MySql?

I learned about this:

desc survey.bb_data

through SO, but this only tells you what the field names are but doesn't show constraints, etc.

Maybe I'm being naive about this but shouldn开发者_运维问答't there be more data (like FK's, etc)?

---

SHOW CREATE TABLE survey.bb_data

That should show all field types and foreign key constraints.

---

I recommend using the following query:

SHOW COLUMNS IN survey.bb_data