list-all-table-in-given-database

Think that you have a database more than 1-2 hundred database tables and you want to get list of all the tables in particular database. I was working on a project with more than 356 table and required to get the list of all the table with column names, column types and length of data type so first I searched for list of table finding query and it give me different different result. Then I thought let me write a quick post about all the available query which can list all the tables from specific database