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


Discover more from Adedeji Olowe

Subscribe to get the latest posts sent to your email.

Author: Adedeji Olowe

Adedeji / a bunch of bananas ate a monkey /

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Discover more from Adedeji Olowe

Subscribe now to keep reading and get access to the full archive.

Continue reading