title: db.DropTables CASCADE on Postgresql
body: <p>Would it be possible To cascade to other table when we drop a table. Postgresql support this feature. </p>
  
  <p>PostgreSQL DROP TABLE syntax
  DROP TABLE [IF EXISTS] table_name [CASCADE | RESTRICT];</p>
  
  <p>I tried with no luck.</p>
  
  <pre><code>    public void CreateDbTable()
      {
          using (IDbConnection db = DbFactory.OpenDbConnection())
          {
  
              using (var trans = db.OpenTransaction())
              {
                  db.ExecuteSql("SET CONSTRAINTS ALL DEFERRED");  
                  db.DropTables(Tables);  -- Add Parameter to Cascade or another methode
                  trans.Commit();
              }
  
              using (var trans = db.OpenTransaction())
              {
                  try
                  {
                      db.CreateTable&lt;Address&gt;();
  
                      db.CreateTable&lt;User&gt;();
                      db.CreateTable&lt;Group&gt;();
                      db.CreateTable&lt;UserGroup&gt;();
  
                      db.CreateTable&lt;Fee.Fee&gt;();
                      db.CreateTable&lt;Event.Event&gt;();
                      db.CreateTable&lt;Event.EventFee&gt;();
                      db.CreateTable&lt;Person.Person&gt;();
                      db.CreateTable&lt;Registration.Registration&gt;();
  
  
  
                      db.CreateTable&lt;Country&gt;();
                      db.CreateTable&lt;Address&gt;();
  
                      db.CreateTable&lt;User&gt;();
                      db.CreateTable&lt;Group&gt;();
                      db.CreateTable&lt;UserGroup&gt;();
  
                      db.CreateTable&lt;Fee.Fee&gt;();
                      db.CreateTable&lt;Event.Event&gt;();
                      db.CreateTable&lt;Event.EventFee&gt;();
                      db.CreateTable&lt;Person.Person&gt;();
                      db.CreateTable&lt;Registration.Registration&gt;();
                      trans.Commit();
                  }
                  catch (Exception)
                  {
                      trans.Rollback();
                      throw;
                  }
              }
          }
      }
  </code></pre>