sp_help for MySql?

Question

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)?

Answer 1

SHOW CREATE TABLE survey.bb_data

That should show all field types and foreign key constraints.