title: DISCARD the tablespace before IMPORT And Cannot Add Foreign Key Cons
body: <p>I was re-creating a table mytab with simple command <code>CREATE TABLE mytab(t INT PRIMARY KEY,NAME VARCHAR(100))</code> but it was giving me below error</p>
  
  <blockquote>
    <p>Error : Tablespace for table '<code>database</code>.<code>mytab</code>' exists. Please
    DISCARD the tablespace before IMPORT.</p>
  </blockquote>
  
  <p>I search and found .ibd physical file on his data directory then I remove it manually and restart the service but now when I am re-executing the command its giving below error:</p>
  
  <blockquote>
    <p>Error Code: 1215 Cannot add foreign key constraint</p>
  </blockquote>