title: Create table in Oracle with auto-increment field using Sqlalchemy
body: <p>I am creating a table in my Oracle DB using python and sqlalchemy. I would like to have an auto-increment ID column as primary key. How can I modify the following code to add the <a href="http://docs.sqlalchemy.org/en/latest/dialects/oracle.html#auto-increment-behavior" rel="nofollow noreferrer">autoload</a> option or anything like that ?</p>
  
  <pre><code>engine = creat_engine("oracle:// ....")
  Base = declarative_base()
  
  class MyTable(Base):
      __tablename__ = 'MyTable'
      ID = Column(Integer, Sequence('my_id_seq'),  primary_key=True)
      SomeColumn = Column(VARCHAR(50))
  
  Base.metadata.create_all(engine)
  </code></pre>
  
  <p>p.s. I don't want to create a separate sequence and trigger (as shown <a href="https://stackoverflow.com/questions/11296361/how-to-create-id-with-auto-increment-on-oracle">here</a>).</p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>when trying to do the following, I get syntax error because of "autoload=True":</p>
  
  <pre><code>class MyTable(Base):
      __table__ = Table('myTable', Base.metadata, autoload=True,
          Column('id', Integer, Sequence('my_id_seq'), primary_key=True),
          Column('somecolumn', VARCHAR(50))
  )
  </code></pre>
  
  <p>SyntaxError: non-keyword arg after keyword arg</p>