Create a Replica Table based on another Table Schema

A quick and dirty way to create a table in MS SQL as a replica of another table without having to move data from first table to the second one. Say you want to create Table B based on Table A schema: SELECT TOP 0 * INTO TABLE B FROM TABLE A

Author: Adedeji Olowe

Adedeji / a bunch of bananas ate a monkey / View all posts by Adedeji Olowe