Sdílet prostřednictvím


Delete Table Dialog Box

Allows you to specify the table from which to delete records. This dialog box appears if more than one table is displayed in the Diagram pane when you change the type of a query to a Delete query.

Select the table to delete records from, and then choose OK.

Poznámka

A Delete query removes entire rows from the table. If you want to clear values from individual data columns, use an Update query. If you want to delete columns from a table definition, or delete the table itself, use Table Designer or the database design tools for your database.

Poznámka

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Working with Settings.

See Also

Tasks

How to: Remove Tables from Queries