PDA

View Full Version : list tables in mysql



sulekha
April 3rd, 2009, 05:08 AM
Hi all,


How to get the list of tables in mysql from a particular database based on engine type(MyISAM,InnoDB,MERGE,HEAP,BDB etc) ?

sujoy
April 3rd, 2009, 05:31 AM
SHOW TABLE STATUS FROM [name of database];

or better yet

$ mysql -u username -p -e "SHOW TABLE STATUS FROM database_name" | awk '{print $1, $2}'|column -t