title: How to query the columns of a table when INFORMATION_SCHEMA gives acces denied?
body: <p>What I am trying to do is get all the columns of a table (the table can be empty)</p>
  
  <p>Example of what I did before:</p>
  
  <pre><code>SELECT COLUMN_NAME 
  FROM INFORMATION_SCHEMA.COLUMNS 
  WHERE table_name = 'aTable' 
    AND table_schema = 'theDatabase'
  </code></pre>
  
  <p>it works perfectly on localhost however on my provider it gives:</p>
  
  <pre><code>#1142 - SELECT command denied to user 'username'@'localhost' for table 'COLUMNS'
  </code></pre>
  
  <p>Is there an alternative that doesn't use the INFORMATION_SCHEMA??</p>