database_tables

Creates, updates, deletes, gets or lists a database_tables resource.

Overview

Name	database_tables
Type	Resource
Id	azure.sql.database_tables

Fields

vw_database_tables

Name	Datatype	Description
databaseName	text	field from the properties object
memory_optimized	text	field from the properties object
resourceGroupName	text	field from the properties object
schemaName	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object
tableName	text	field from the properties object
temporal_type	text	field from the properties object

database_tables

Name	Datatype	Description
properties	object	Database table properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, resourceGroupName, schemaName, serverName, subscriptionId, tableName	Get database table
list_by_schema	SELECT	databaseName, resourceGroupName, schemaName, serverName, subscriptionId	List database tables

SELECT examples

List database tables

vw_database_tables

SELECT
databaseName,
memory_optimized,
resourceGroupName,
schemaName,
serverName,
subscriptionId,
tableName,
temporal_type
FROM azure.sql.vw_database_tables
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND schemaName = '{{ schemaName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

database_tables

SELECT
properties
FROM azure.sql.database_tables
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND schemaName = '{{ schemaName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';