Each database object (table, index, view, default, constraint, trigger, rule, and stored procedure) has a designated owner. The user who creates a database object is the database object owner and is automatically granted all permissions to it. The database object owner is not necessarily the database owner. Any user who has permission to create a database can be a database object owner.
Database diagrams enable you to work with a table that is owned by another user. For example, you can move a column from a table that you don’t own to a table that you just created. If you have sufficient permissions to modify the database with your changes, you can do so by saving your diagram.
Note If you don’t have sufficient permissions to modify the database, you can save your changes in a Transact-SQL change script that the database owner can later apply to the database.
If the database diagram contains tables that are not owned by the database owner, the name of the database object owner appears in parentheses at the end of the table name.
Saving a Change Script |