Last updated on
Apr 27, 2021
Description
The DeleteTable function deletes a table and all items present in the table.
For more information, see DeleteTable.
Category
History
ColdFusion (2021 release): Added this function.
Syntax
serviceHandle.deleteTable(requestParameters)
serviceHandle.deleteTable(requestParameters)
serviceHandle.deleteTable(requestParameters)
Parameters
See request parameters of DeleteTable.
Example
<cfscript>
cred = {
"credentialAlias" : "myalias",
"vendorName" : "AWS",
"region" : "us-east-2",
"secretAccessKey" : "xxxxx",
"accessKeyId" : "xxxx"
}
config = {
"serviceName" = "DYNAMODB"
}
dynamo = getCloudService(cred, config)
tableName="YearlyProductCatalog"
// create a table
createTableStruct={
"TableName": "#tableName#",
"KeySchema": [
{
"AttributeName": "id","KeyType": "HASH"
},
{
"AttributeName": "title","KeyType": "RANGE"
}
],
"AttributeDefinitions": [
{
"AttributeName": "id",
"AttributeType": "N"
},
{
"AttributeName": "title",
"AttributeType": "S"
}
],
"ProvisionedThroughput": {
"ReadCapacityUnits": 10,
"WriteCapacityUnits": 10
}
}
dynamo.createTable(createTableStruct)
sleep(20000)
// insert an item
putItemStruct = {
"TableName": "#tableName#",
"Item":{
"id": {"N": 550},
"title": {"S": "My Books Title"}
},
"ReturnValues": "NONE"
}
dynamo.putItem(putItemStruct,{"hasType": true})
// delete the table
deleteTableStruct={
"TableName": "#tableName#"
}
try{
deleteResponse=dynamo.deleteTable(deleteTableStruct)
writeOutput("Table deleted successfully")
writeDump(deleteResponse)
}
catch (any e){
writeOutput("Unable to delete the table")
writeDump(e)
}
</cfscript>
<cfscript>
cred = {
"credentialAlias" : "myalias",
"vendorName" : "AWS",
"region" : "us-east-2",
"secretAccessKey" : "xxxxx",
"accessKeyId" : "xxxx"
}
config = {
"serviceName" = "DYNAMODB"
}
dynamo = getCloudService(cred, config)
tableName="YearlyProductCatalog"
// create a table
createTableStruct={
"TableName": "#tableName#",
"KeySchema": [
{
"AttributeName": "id","KeyType": "HASH"
},
{
"AttributeName": "title","KeyType": "RANGE"
}
],
"AttributeDefinitions": [
{
"AttributeName": "id",
"AttributeType": "N"
},
{
"AttributeName": "title",
"AttributeType": "S"
}
],
"ProvisionedThroughput": {
"ReadCapacityUnits": 10,
"WriteCapacityUnits": 10
}
}
dynamo.createTable(createTableStruct)
sleep(20000)
// insert an item
putItemStruct = {
"TableName": "#tableName#",
"Item":{
"id": {"N": 550},
"title": {"S": "My Books Title"}
},
"ReturnValues": "NONE"
}
dynamo.putItem(putItemStruct,{"hasType": true})
// delete the table
deleteTableStruct={
"TableName": "#tableName#"
}
try{
deleteResponse=dynamo.deleteTable(deleteTableStruct)
writeOutput("Table deleted successfully")
writeDump(deleteResponse)
}
catch (any e){
writeOutput("Unable to delete the table")
writeDump(e)
}
</cfscript>
<cfscript> cred = { "credentialAlias" : "myalias", "vendorName" : "AWS", "region" : "us-east-2", "secretAccessKey" : "xxxxx", "accessKeyId" : "xxxx" } config = { "serviceName" = "DYNAMODB" } dynamo = getCloudService(cred, config) tableName="YearlyProductCatalog" // create a table createTableStruct={ "TableName": "#tableName#", "KeySchema": [ { "AttributeName": "id","KeyType": "HASH" }, { "AttributeName": "title","KeyType": "RANGE" } ], "AttributeDefinitions": [ { "AttributeName": "id", "AttributeType": "N" }, { "AttributeName": "title", "AttributeType": "S" } ], "ProvisionedThroughput": { "ReadCapacityUnits": 10, "WriteCapacityUnits": 10 } } dynamo.createTable(createTableStruct) sleep(20000) // insert an item putItemStruct = { "TableName": "#tableName#", "Item":{ "id": {"N": 550}, "title": {"S": "My Books Title"} }, "ReturnValues": "NONE" } dynamo.putItem(putItemStruct,{"hasType": true}) // delete the table deleteTableStruct={ "TableName": "#tableName#" } try{ deleteResponse=dynamo.deleteTable(deleteTableStruct) writeOutput("Table deleted successfully") writeDump(deleteResponse) } catch (any e){ writeOutput("Unable to delete the table") writeDump(e) } </cfscript>
Output