Work with database objects
Last modified: July 22, 2025
This section describes how to manage database objects such as tables, views, keys, constraints, triggers, and stored procedures. It explains how to create, copy, modify, and delete objects, define table structures, and edit table data. Additional topics include filtering and counting objects, generating DDL and DML statements, viewing dependencies, and identifying invalid objects.
In this section
- Create a database object
- Create a copy of a database object
- Delete a database object
- Display the number of database objects
- Filter database objects
- Create, view, drop, and edit tables
- Define table structure
- Alternative table editing
- Alter an existing table
- View and edit table data
- Unique and primary keys
- Primary keys
- Check constraints
- Foreign keys
- Work with views
- Generate the DDL and DML statements for database objects
- Work with stored procedures
- Create a trigger
- View object dependencies
- Find invalid objects
Was this page helpful?
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 tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.