---
title: "How to create an empty table from an existing table?"  
description: "How to create an empty table from an existing table?"  
author: "Anonymous User"  
published: 2019-07-05  
updated: 2020-09-23  
canonical: https://www.mindstick.com/interview/23538/how-to-create-an-empty-table-from-an-existing-table  
category: "mssql server"  
tags: ["sql server", "sql", "sql server 2008"]  
reading_time: 1 minute  

---

# How to create an empty table from an existing table?

An example will be -.

```
Select * into studentcopy from student where 1=2
```

Here, we are copying the **student table** to another table with the same structure with no rows copied.

## Answers

### Answer by Anonymous User

An example will be -.

```
Select * into studentcopy from student where 1=2
```

Here, we are copying the **student table** to another table with the same structure with no rows copied.


---

Original Source: https://www.mindstick.com/interview/23538/how-to-create-an-empty-table-from-an-existing-table

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