Managing Data

After you create a database, tables, and indexes, you can put data into the tables and work with it—adding, changing, transferring, and deleting as necessary.

The commands you use to add, change, or delete data are called data modification statements. These commands include:

See the Reference Manual: Commands.

You can also add data to a table by transferring it from a file using the bulk-copy utility program, bcp. See the Utility Guide.

You can use insert, update, or delete to modify data in one table per statement. Transact-SQL enhancements to these commands let you base modifications on data in other tables, and even other databases.

The data modification commands also work on views, with some restrictions.

Database owners and the owners of database objects can use the grant and revoke commands to specify the users who are allows to execute data modification commands.Permissions or privileges can be granted to individual users, groups, or the public for any combination of the data modification commands. Permissions are discussed in, Managing User Permissions, in the System Administration Guide: Volume 1.

Related concepts
Views: Limit Access to Data