title: T-SQL - batch delimiter required
body: <p>I am trying to build Visual Studio solution for Azure SQL Database.</p>
  <p>I have SQL script with <code>CREATE TABLE</code> and its extended attributes:</p>
  <pre class="lang-sql prettyprint-override"><code>create table schema.table_name (
     table_name_Key integer not null,
     constraint PK_table_Name primary key (table_Name_Key, Some_Column)
  )
  go
  
  if exists (select 1 from  sys.extended_properties
             where major_id = object_id('table_name') and minor_id = 0)
  begin 
     execute sp_dropextendedproperty 'MS_Description',  
     'user', 'schema', 'table', 'table_name' ;
  end 
  
  execute sp_addextendedproperty 'MS_Description',  
     'This table will be used for ....', 
     'user', 'schema', 'table', 'table_name';
  go
  
  if exists (select 1 from sys.extended_properties p 
             where p.major_id = object_id('table_name')
               and p.minor_id = (select c.column_id from sys.columns c 
                                 where c.object_id = p.major_id 
                                   and c.name = 'table_name_Key'))
  begin
     execute sp_dropextendedproperty 'MS_Description', 
     'user', 'schema', 'table', 'table_name', 'column', 'table_name_Key';
  end
  
  execute sp_addextendedproperty 'MS_Description', 
     'Primary Key of table_name table',
     'user', 'schema', 'table', 'table_name', 'column', 'table_name_Key';
  go
  </code></pre>
  <p>I am still getting errors when building that I am missing batch delimiter:</p>
  <blockquote>
  <p>Error SQL71006: Only one statement is allowed per batch. A batch separator, such as 'GO', might be required between statements.</p>
  </blockquote>
  <p>What am I missing and where? I already tried to add <code>go</code> after <code>end</code> but still error.</p>