---
title: "how to copy data and structure from a table in sql server"  
description: "In this article we are going to how to copy an existing table to new table in SQL Server with an example."  
author: "Anonymous User"  
published: 2018-07-12  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/13007/how-to-copy-data-and-structure-from-a-table-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 2 minutes  

---

# how to copy data and structure from a table in sql server

## Introduction:

In this article we are going to how to copy an existing table to new table in [SQL Server](https://www.mindstick.com/Articles/564/sql-introduction) with an example.

## Description:

The [SQL Server](https://www.mindstick.com/Articles/564/sql-introduction) (Transact-SQL) SELECT INTO statement is used to create a new table from an existing table by copying the existing table's schema and data. It is important to note that when creating a table in this way, the new table will be populated with the records from the existing table (based on the SELECT Statement).

## Let’s see simple an example of SELECT INTO statement

## CUSTOMER TABLE

![how to copy data and structure from a table in sql server](https://www.mindstick.com/mindstickarticle/c10512c9-d3a3-4086-b852-ff8e945fe65e/images/089a1eaa-9b6f-4712-bd7b-4f9d52aee185.png)

## SELECT INTO statement

```
SELECT * INTO NEW_CUSTOMER from CUSTOMER
```

NEW_CUSTOMER TABLE

![how to copy data and structure from a table in sql server](https://www.mindstick.com/mindstickarticle/c10512c9-d3a3-4086-b852-ff8e945fe65e/images/089a1eaa-9b6f-4712-bd7b-4f9d52aee185.png)

In above example, we have a customer table, which is copied customer table data and schema to the new Customer table.

I hope it will help you after reading it.

you might also like to read next topic [how to import excel data in](https://www.mindstick.com/Articles/12937/how-to-import-excel-data-in-sql-server-2014) [sql](https://www.mindstick.com/Articles/12937/how-to-import-excel-data-in-sql-server-2014) [server database](https://www.mindstick.com/Articles/12937/how-to-import-excel-data-in-sql-server-2014) , [use Cursor in SQL server](https://www.mindstick.com/Articles/13003/create-a-simple-cursor-in-sql-server), [subquery](https://www.mindstick.com/Articles/13006/subquery-in-sql-with-example) [in](https://www.mindstick.com/Articles/13006/subquery-in-sql-with-example) [sql](https://www.mindstick.com/Articles/13006/subquery-in-sql-with-example) [with](https://www.mindstick.com/Articles/13006/subquery-in-sql-with-example) [example](https://www.mindstick.com/Articles/13006/subquery-in-sql-with-example) , [how to create Table-valued functions in SQL](https://www.mindstick.com/Articles/12999/what-is-table-valued-function-in-sql-server)

\

\

---

Original Source: https://www.mindstick.com/articles/13007/how-to-copy-data-and-structure-from-a-table-in-sql-server

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