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

Post a Comment

Your email is never published nor shared. Required fields are marked *

%d bloggers like this: