SALES: 1-800-867-1380
This topic has not yet been rated - Rate this topic

Delete Table (REST API)

Updated: July 26, 2013

The Delete Table operation deletes the specified table and any data it contains.

The Delete Table request may be constructed as follows. HTTPS is recommended. Replace myaccount with the name of your storage account, and mytable with the name of the table to be deleted:

 

Method Request URI HTTP Version

DELETE

https://myaccount.table.core.windows.net/Tables('mytable')

HTTP/1.1

Emulated Storage Service URI

When making a request against the emulated storage service, specify the emulator hostname and Table service port as 127.0.0.1:10002, followed by the emulated storage account name:

 

Method Request URI HTTP Version

DELETE

http://127.0.0.1:10002/devstoreaccount1/Tables('mytable')

HTTP/1.1

The Table service in the emulated storage service differs from the Windows® Azure™ Table service in several ways. For more information, see About Development Storage and Differences Between the Storage Emulator and Windows Azure Storage Services.

URI Parameters

None.

Request Headers

The request must include the Authorization header and either the Date or x-ms-date header, as specified in Authentication for the Windows Azure Storage Services. Additional headers are described in the following table.

 

Request header Description

Authorization

Required. Specifies the authentication scheme, account name, and signature. For more information, see Authentication for the Windows Azure Storage Services.

Date or x-ms-date

Required. Specifies the Coordinated Universal Time (UTC) for the request. For more information, see Authentication for the Windows Azure Storage Services.

x-ms-version

Optional. Specifies the version of the operation to use for this request. For more information, see Versioning for the Blob, Queue, and Table Services in Windows Azure.

Content-Type

Required. The content type of the request body. Currently, this header should be set to application/atom+xml.

x-ms-client-request-id

Optional. Provides a client-generated, opaque value with a 1 KB character limit that is recorded in the analytics logs when storage analytics logging is enabled. Using this header is highly recommended for correlating client-side activities with requests received by the server. For more information, see About Storage Analytics Logging and Windows Azure Logging: Using Logs to Track Storage Requests.

Request Body

None.

The response includes an HTTP status code and a set of response headers.

Status Code

A successful operation returns status code 204 (No Content).

For information about status codes, see Status and Error Codes and Table Service Error Codes.

Response Headers

The response for this operation includes the following headers. The response may also include additional standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.

 

Response header Description

x-ms-request-id

This header uniquely identifies the request that was made and can be used for troubleshooting the request. For more information, see Troubleshooting API Operations.

x-ms-version

Indicates the version of the Table service used to execute the request. This header is returned for requests made against version 2009-09-19 and later.

Date

A UTC date/time value generated by the service that indicates the time at which the response was initiated.

Response Body

None.

Only the account owner may call this operation.

When a table is successfully deleted, it is immediately marked for deletion and is no longer accessible to clients. The table is later removed from the Table service during garbage collection.

Note that deleting a table is likely to take at least 40 seconds to complete. If an operation is attempted against the table while it was being deleted, the service returns status code 409 (Conflict), with additional error information indicating that the table is being deleted.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.