Is it possible, from the MySQL command line, to list in a single query all the indexes/constraints/FKs etc that are in the database in question?
Thanks in advance
We can also refer to INFORMATION_SCHEMA.TABLE_CONSTRAINTS dictionary table providing TABLE_SCHEMA and CONSTRAINT_TYPE in where clause/
CONSTRAINT_TYPE could be 'UNIQUE'/'PRIMARY KEY'/FOREIGN KEY'
Take a look into information_schema database, maybe these tables can help you: