title: Cloning a Table without using SELECT TOP (0) * INTO
body: <p>I need to create a copy of a database table.
  I require to set the TEXTIMAGE_ON value which can only be created at Creation time and not with ALTER TABLE afterwards.</p>
  
  <p>I am also not allowed to alter any database properties beforehand. So basically NOT:</p>
  
  <pre><code>ALTER DATABASE backoffice MODIFY FILEGROUP filegroup DEFAULT
  </code></pre>
  
  <p>Thats the reason why i can't just use:</p>
  
  <pre><code>SELECT TOP (0) * INTO [DestinationSchema].[DestinationTable] FROM [SourceSchema].[SourceTable]
  </code></pre>
  
  <p>to clone my table.</p>
  
  <p>I am looking basically for a script or any other way to which creates the table and than clones the columns step by step.</p>
  
  <p>I am grateful for any help.</p>