Returns information for buckets. Buckets are used to store objects, which consist of data and its metadata.

Table Specific Information

Select

The add-in uses the Amazon S3 API to process search criteria that refers to the Name column. The add-in processes other filters client side within the add-in. For example, the following queries are processed server side.

SELECT * FROM Buckets

SELECT * FROM Buckets WHERE Name = 'TestBucket'

Insert

To insert a Bucket, specify the primary key of the Bucket in the INSERT query. For example, the following query inserts a bucket from Amazon S3:

INSERT INTO Buckets (Bucket) VALUES ('TestBucket')

Delete

To delete a Bucket, specify the primary key of the Bucket in the DELETE query. For example, the following query deletes a bucket from Amazon S3:

DELETE FROM Buckets WHERE Bucket = 'MyBucket'

Columns