Get-AzStorageTable

In this Azure PowerShell article, we will discuss the syntax and usage of the Get-AzStorageTable Azure PowerShell command with certain examples.

Table of Contents

Get-AzStorageTable
- Syntax
- Examples
  - Example-1
  - Example-2
Wrapping Up

Get-AzStorageTable is an excellent PowerShell command that can help you retrieve the lists of available storage tables associated with the specified Storage account.

Syntax

Below is the syntax of the Get-AzStorageTable Azure PowerShell command.

Get-AzStorageTable

Get-AzStorageTable
 [[-Name] <String>]

Get-AzStorageTable
 -Prefix <String>

Examples

Let’s discuss a few examples of how to use the Get-AzStorageTable PowerShell command.

Example-1

You can execute the below Azure PowerShell command that can help you retrieve the lists of available storage tables associated with the specified Storage account.

$mysARG = "Demo123"
$mysAName = "demo123b08c"
$mysAKey = (Get-AzStorageAccountKey -ResourceGroupName $mysARG -AccountName $mysAName).Value[0]
$myctx = New-AzStorageContext -StorageAccountName $mysAName -StorageAccountKey $mysAKey
Get-AzStorageTable -Context $myctx

After executing the above PowerShell command, I got the below-expected output.


   Table End Point: https://demo123b08c.table.core.windows.net/

Name                                 Uri                                                                            
----                                 ---                                                                            
AzureFunctionsScaleMetrics202309     https://demo123b08c.table.core.windows.net/AzureFunctionsScaleMetrics202309    
flowf433c9d06f75f95flowsubscriptions https://demo123b08c.table.core.windows.net/flowf433c9d06f75f95flowsubscriptions
flowf433c9d06f75f95jobdefinitions    https://demo123b08c.table.core.windows.net/flowf433c9d06f75f95jobdefinitions

You can check out the same output as below

Note: Make sure to pass the storage context with the Get-AzStorageTable command, else you will get the error Get-AzStorageTable: Could not get the storage context. Please pass in a storage context or set the current storage context.

Example-2

Below Azure PowerShell command can help you to get the lists of Azure Storage tables those names start with the specified name/wild character.

$mysARG = "Demo123"
$mysAName = "demo123b08c"
$mysAKey = (Get-AzStorageAccountKey -ResourceGroupName $mysARG -AccountName $mysAName).Value[0]
$myctx = New-AzStorageContext -StorageAccountName $mysAName -StorageAccountKey $mysAKey
Get-AzStorageTable -Name flow* -Context $myctx

After executing the above PowerShell script, I got the below-expected output.

Similarly, you can use the New-AzStorageTable PowerShell command to create a brand-new Azure storage table.

Wrapping Up

In this Azure PowerShell article, we discussed the syntax and usage of the Get-AzStorageTable Azure PowerShell command with certain examples. Thanks for reading this article !!!