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.
Keyspace is required unless you specified a working keyspace when instantiating 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 if you specified a working keyspace when you created the Default: The working keyspace set when you created the |
Examples
The following examples demonstrate how to drop a table.
Drop a table by name
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(
new CommandOptions() { Destination = DataAPIDestination.HCD }
);
var database = client.GetDatabase(
"API_ENDPOINT",
DataAPIClient.UsernamePasswordTokenProvider(
"USERNAME",
"PASSWORD"
),
"KEYSPACE_NAME"
);
// 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;
using DataStax.AstraDB.DataApi.Core;
namespace Examples;
public class Program
{
static async Task Main()
{
// Get an existing table
var client = new DataAPIClient(
new CommandOptions() { Destination = DataAPIDestination.HCD }
);
var database = client.GetDatabase(
"API_ENDPOINT",
DataAPIClient.UsernamePasswordTokenProvider(
"USERNAME",
"PASSWORD"
),
"KEYSPACE_NAME"
);
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(
new CommandOptions() { Destination = DataAPIDestination.HCD }
);
var database = client.GetDatabase(
"API_ENDPOINT",
DataAPIClient.UsernamePasswordTokenProvider(
"USERNAME",
"PASSWORD"
),
"KEYSPACE_NAME"
);
// Drop a table
await database.DropTableAsync(
"TABLE_NAME",
new DropTableOptions() { IfExists = true }
);
}
}Client reference
For more information, see the client reference.
