---
title: "Save Your Work in Table Designer (Visual Database Tools) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology:
ms.topic: conceptual
helpviewer_keywords: 
  - "tables [SQL Server], saving"
  - "Table Designer, saving work"
  - "saving tables"
ms.assetid: 676e4a9a-be75-44d2-b011-6e7fb921de4a
author: mashamsft
ms.author: mathoma
manager: craigg
---
# Save Your Work in Table Designer (Visual Database Tools)
  You can save changes to tables that are open in Table Designer.  
  
### To save a table  
  
1.  Click anywhere in the Table Designer.  
  
2.  From the **File** menu, choose **Save**_tablename_.  
  
3.  In the **Save** dialog box, click **Yes** to update the database.  
  
> [!NOTE]  
>  If the changes you are saving cause no changes to other tables, you won't see this dialog.  
  
> [!NOTE]  
>  The list of tables in the **Save** dialog box may include tables other than the one you modified. For example, if you change the data type of a column that participates in a relationship with another table, both tables will be included in this list.  
  
> [!NOTE]  
>  To save changes to all open items, such as tables, views, stored procedures, from the **File** menu choose **Save All**.  
  
## See Also  
 [Table Properties (Visual Database Tools)](../ssms/visual-db-tools/visual-database-tools.md)