<p>The SQL produced for any table with an identity column will be invalid.</p>
<pre><code>[1] fake.fake.1> sp_help TestProducer;
Name Owner Object_type Object_status Create_date
------------------------ ---------- ---------------------- -------------------------- --------------------------------------
TestProducer dbo user table -- none -- Jul 13 2017 12:42PM
(1 row affected)
Column_name Type Length Prec Scale Nulls Not_compressed Default_name Rule_name Access_Rule_name Computed_Column_object Identity
---------------------- -------------- ------------ -------- ---------- ---------- ---------------------------- ------------------------ ------------------ -------------------------------- -------------------------------------------- --------------------
TestID numeric 5 9 0 0 0 NULL NULL NULL NULL 1
TestVar varchar 2 NULL NULL 0 0 NULL NULL NULL NULL 0
TestChr char 1 NULL NULL 1 0 NULL NULL NULL NULL 0
Object does not have any indexes.
No defined keys for this object.
</code></pre>
<p>If I have SQL::Translator::Producer::Sybase dump out the SQL for this table then I get this (comments and blank lines removed):</p>
<pre><code>CREATE TABLE TestProducer (
TestID IDENTITY numeric(9,0) NOT NULL,
TestVar varchar(2) NOT NULL,
TestChr char(1) NULL
);
</code></pre>
<p>Notice that IDENTITY falls before the datatype which is invalid, will not load in Sybase and rightly causes SQL::Translator::Parser::Sybase to error out.</p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/issues/93">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAlgBGoVklVP5bEXMewUMa3J386cjks5sNlfngaJpZM4OXUzH">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AASeAitGSFOnwUiOL4GHz52GpgATwE-Tks5sNlfngaJpZM4OXUzH.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
<link itemprop="url" href="https://github.com/dbsrgits/sql-translator/issues/93"></link>
<meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"SQL::Translator::Producer::Sybase generates invalid CREATE TABLE statements (#93)"}],"action":{"name":"View Issue","url":"https://github.com/dbsrgits/sql-translator/issues/93"}}}</script>