How to create, drop, and edit tables
This topic describes ways to create, drop, and edit a table in a database with the help of dbForge Studio.
Creating a Table
- In Database Explorer, right-click the Tables node and select New Table.
- Input the table name.
- Add at least one column to the table.
- Optionally, alter the name, change database (owner) in which the new table will be created, or set comment for the table.
- Save the document.
Note
To learn about adding columns, constraints, indexes to the table and defining other table parameters, see Defining Table Structure.
Dropping a Table
Drop table by selecting Delete from node shortcut menu.
Note
When you drop a table all data containing in it is lost.
Editing a Table
Editing a table implies editing its structure: changing, removing, or adding columns, indexes, modifying table options. Table editor allows performing all these actions and viewing changes in the script of the table.
To edit a table and view changes:
- Right-click it in Database Explorer.
- Click Edit Table on the shortcut menu.
- Make necessary changes in table structure. See Defining Table Structure for detailed information.
-
Click Script Changes to view changes.
- To apply changes, click Update Database. If you want to undo all actions made since table document (or any another object editor) was opened or saved, click Undo on the Standard toolbar. However, you cannot issue a Redo command for database objects, because when you click Undo, the database object is reloaded from server, and all unsaved changes are lost.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?