Terraform workspaces (OSS) allow you to create a new workspace to execute the same Terraform but with a different state file. This feature will enable you to run the same Terraform with different configurations without modifying Terraform code or impacting any existing workspaces. Terraform states out with the default workspace, and that's the workspace you are using unless you create and switch to a new workspace.
IMPORTANT - PLEASE READ:
Remember that Terraform Cloud and Enterprise also have Workspaces, but they behave slightly differently. In Cloud and Ent, each workspace is still isolated from others, meaning it has its own state. Still, often these workspaces point to different code repositories and use completely different Terraform configuration files.
To create a new workspace, you'd run:
$ terraform workspace new btk
Created and switched to workspace "btk"!
You're now on a new, empty workspace. Workspaces isolate their state, so if you run "terraform plan" Terraform will not see any existing state for this configuration.
To list all of the existing workspaces, you can run (note the * indicates the workspace you are using):
$ terraform workspace list
default*
btk
bryan-dev
temp-workspace
WRONG ANSWER:
When using workspaces, you're essentially using the same Terraform configuration files. Therefore the backend will remain the same for all of your workspaces. That makes this answer incorrect.
https://www.terraform.io/language/state/workspaces
https://www.terraform.io/cli/commands/workspace/list
https://www.terraform.io/cli/commands/workspace/new