Creating and Managing Database Objects

The developer typically creates and manages objects in a database. These objects include tables, views, indexes, constraints defaults, triggers, and procedures. For details on these objects, see Working with Tables.

Note In some cases, the database developer is not the owner of a database. However, with permission from the database owner, a developer can create objects in the database.

The developer who creates an object owns the object and can explicitly grant permission to others to use the object. By default, even the database owner cannot use the object unless the object's owner grants the appropriate permission. For details on permissions, see the Microsoft SQL Server Administrator's Companion.