title: Get all table names of a particular database by SQL query?
body: <p>I am working on application which can deal with multiple database servers like &quot;MySQL&quot; and &quot;MS SQL Server&quot;.</p>
  <p>I want to get tables' names of a particular database using a general query which should suitable for all database types. I have tried following:</p>
  <pre><code>SELECT TABLE_NAME
  FROM INFORMATION_SCHEMA.TABLES
  WHERE TABLE_TYPE='BASE TABLE'
  </code></pre>
  <p>But it is giving table names of all databases of a particular server but I want to get tables names of selected database only. How can I restrict this query to get tables of a particular database?</p>