Skip to content

Instantly share code, notes, and snippets.

@aquasmit

aquasmit/create-table-like-alternative-for-sqlserver.sql

Created July 10, 2018 14:07
Show Gist options
  • Save aquasmit/c3d6162f38c0d9528afe7cdf1c2aa684 to your computer and use it in GitHub Desktop.
Save aquasmit/c3d6162f38c0d9528afe7cdf1c2aa684 to your computer and use it in GitHub Desktop.
Download ZIP
sqlserver-create-table-like-alternative-for-sqlserver
Raw
create-table-like-alternative-for-sqlserver.sql
/*This will create new table 'newTableNameToBeCreated' with same structure as 'myRealTable' */
/* no data will be inserted into the new table */
SELECT *
into newTableNameToBeCreated
FROM myRealTable
where 0=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment