title: Liquibase: How do I set the autoincrement seed and increment in SQL Server
body: <p>I have a table:</p>
  
  <pre><code>CREATE TABLE dbo.Courses
  (
      courseID BIGINT IDENTITY(-1,-1) NOT NULL,
      courseName NVARCHAR(100) NOT NULL
  );
  </code></pre>
  
  <p>I am trying to convert this to liquibase</p>
  
  <pre><code>  - createTable:
      tableName: Courses
      columns:
      - column:
          name: courseID
          type: bigint
          autoIncrement: true
      - column:
          name: courseName
          type: nvarchar(100)
          constraints:
              nullable: false
  </code></pre>
  
  <p>The liquibase code generates</p>
  
  <pre><code>CREATE TABLE Courses
  (
        courseID BIGINT IDENTITY (1, 1), 
        courseName NVARCHAR(100) NOT NULL
  )
  GO
  </code></pre>
  
  <p>I tried not setting <code>autoIncrement: true</code> and then adding <code>addAutoIncrement</code> after the create table but that returned:</p>
  
  <blockquote>
    <p>ERROR liquibase.integration.commandline.Main - Unexpected error running Liquibase: Validation Failed:<br>
    1 changes have validation failures<br>
    addAutoIncrement is not supported on mssql, baselineTables.yml::Courses::user</p>
  </blockquote>
  
  <p>Next I tried to change it manually using T-SQL:</p>
  
  <pre><code>ALTER TABLE Courses 
      ALTER COLUMN CourseID IDENTITY (-1, -1)
  </code></pre>
  
  <p>But I get a SQL Server error.</p>
  
  <p>Any idea how I can get liquibase to set an identity seed and increment to anything but (1,1)?</p>