---
title: "How will you copy the structure of a table without copying the data?"  
description: "How will you copy the structure of a table without copying the data?"  
author: "Chris Anderson"  
published: 2011-09-17  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/1266/how-will-you-copy-the-structure-of-a-table-without-copying-the-data  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How will you copy the structure of a table without copying the data?

There is one method for copying the structure of table without copying the data is\
\
create table NEWTABLE as select * from OLDTABLE where 1=2

\

## Answers

### Answer by Shekhar Kumar

There is one method for copying the structure of table without copying the data is\
SELECT * INTO NewTable FROM OldTable Where 1=2

### Answer by Chris Anderson

There is one method for copying the structure of table without copying the data is\
\
create table NEWTABLE as select * from OLDTABLE where 1=2

\


---

Original Source: https://www.mindstick.com/interview/1266/how-will-you-copy-the-structure-of-a-table-without-copying-the-data

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.