When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to save a table, they should follow the next steps:
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.