Drop a table (C#)
Deletes a table from a database, including all data stored in the table.
|
Ready to write code? See the examples for this method to get started. If you are new to the Data API, check out the quickstart. |
Result
Deletes the specified table from the database, including all data stored in the table.
Does not return anything.
Parameters
Use the DropTableAsync method, which belongs to the Database class.
You can also use DropTable, which is the synchronous version of the method.
Method signature
public Task DropTableAsync(
string tableName, DropTableOptions options = null
);public Task DropTableAsync<TRow>(
DropTableOptions options = null
) where TRow : class, new();| Name | Type | Summary |
|---|---|---|
|
|
The name of the table to drop. |
|
Optional.
Options for this operation.
For more information and examples for general options such as timeout and keyspace, see Customize API interaction.
For options specific to this method, see Method-specific properties of the |
| Name | Type | Summary |
|---|---|---|
|
|
Optional. Whether the command should silently succeed even if a table with the given name does not exist in the keyspace and no table was dropped. For an example, see Drop a table only if the table exists. Default: false |
|
|
Optional. The keyspace containing the table. Default: The working keyspace for the database.
This is |
Examples
The following examples demonstrate how to drop a table.
Drop a table by name
using DataStax.AstraDB.DataApi;
namespace Examples;
public class Program
{
static async Task Main()
{
// Get an existing database
var client = new DataAPIClient();
var database = client.GetDatabase(
"API_ENDPOINT",
"APPLICATION_TOKEN"
);
// Drop a table
await database.DropTableAsync("TABLE_NAME");
}
}Drop a table through a Table object
If you get a Table object through one of the clients, you can drop the table through that object.
using DataStax.AstraDB.DataApi;
namespace Examples;
public class Program
{
static async Task Main()
{
// Get an existing table
var client = new DataAPIClient();
var database = client.GetDatabase(
"API_ENDPOINT",
"APPLICATION_TOKEN"
);
var table = database.GetTable("TABLE_NAME");
// Drop the table
await table.DropAsync();
}
}Drop a table only if the table exists
Use this option to silently do nothing if a table with the specified name does not exist.
using DataStax.AstraDB.DataApi;
using DataStax.AstraDB.DataApi.Core;
namespace Examples;
public class Program
{
static async Task Main()
{
// Get an existing database
var client = new DataAPIClient();
var database = client.GetDatabase(
"API_ENDPOINT",
"APPLICATION_TOKEN"
);
// Drop a table
await database.DropTableAsync(
"TABLE_NAME",
new DropTableOptions() { IfExists = true }
);
}
}Client reference
For more information, see the client reference.
