@datafire/azure_sql_manageddatabaseschema v3.0.0

@datafire/azure_sql_manageddatabaseschema

Client library for SqlManagementClient

Installation and Usage

npm install --save @datafire/azure_sql_manageddatabaseschema

let azure_sql_manageddatabaseschema = require('@datafire/azure_sql_manageddatabaseschema').create({
  access_token: "",
  refresh_token: "",
  client_id: "",
  client_secret: "",
  redirect_uri: ""
});

.then(data => {
  console.log(data);
});

Description

The Azure SQL Database management API provides a RESTful set of web APIs that interact with Azure SQL Database services to manage your databases. The API enables users to create, retrieve, update, and delete databases, servers, and other entities.

Actions

ManagedDatabaseSchemas_ListByDatabase

List managed database schemas

azure_sql_manageddatabaseschema.ManagedDatabaseSchemas_ListByDatabase({
  "resourceGroupName": "",
  "managedInstanceName": "",
  "databaseName": "",
  "subscriptionId": "",
  "api-version": ""
}, context)

Input

• input object
  • resourceGroupName required string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
  • managedInstanceName required string: The name of the managed instance.
  • databaseName required string: The name of the database.
  • $filter string: An OData filter expression that filters elements in the collection.
  • subscriptionId required string: The subscription ID that identifies an Azure subscription.
  • api-version required string: The API version to use for the request.

Output

• output DatabaseSchemaListResult

ManagedDatabaseSchemas_Get

Get managed database schema

azure_sql_manageddatabaseschema.ManagedDatabaseSchemas_Get({
  "resourceGroupName": "",
  "managedInstanceName": "",
  "databaseName": "",
  "schemaName": "",
  "subscriptionId": "",
  "api-version": ""
}, context)

Input

• input object
  • resourceGroupName required string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
  • managedInstanceName required string: The name of the managed instance.
  • databaseName required string: The name of the database.
  • schemaName required string: The name of the schema.
  • subscriptionId required string: The subscription ID that identifies an Azure subscription.
  • api-version required string: The API version to use for the request.

Output

• output DatabaseSchema

ManagedDatabaseTables_ListBySchema

List managed database tables

azure_sql_manageddatabaseschema.ManagedDatabaseTables_ListBySchema({
  "resourceGroupName": "",
  "managedInstanceName": "",
  "databaseName": "",
  "schemaName": "",
  "subscriptionId": "",
  "api-version": ""
}, context)

Input

• input object
  • resourceGroupName required string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
  • managedInstanceName required string: The name of the managed instance.
  • databaseName required string: The name of the database.
  • schemaName required string: The name of the schema.
  • $filter string: An OData filter expression that filters elements in the collection.
  • subscriptionId required string: The subscription ID that identifies an Azure subscription.
  • api-version required string: The API version to use for the request.

Output

• output DatabaseTableListResult

ManagedDatabaseTables_Get

Get managed database table

azure_sql_manageddatabaseschema.ManagedDatabaseTables_Get({
  "resourceGroupName": "",
  "managedInstanceName": "",
  "databaseName": "",
  "schemaName": "",
  "tableName": "",
  "subscriptionId": "",
  "api-version": ""
}, context)

Input

• input object
  • resourceGroupName required string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
  • managedInstanceName required string: The name of the managed instance.
  • databaseName required string: The name of the database.
  • schemaName required string: The name of the schema.
  • tableName required string: The name of the table.
  • subscriptionId required string: The subscription ID that identifies an Azure subscription.
  • api-version required string: The API version to use for the request.

Output

• output DatabaseTable

ManagedDatabaseColumns_ListByTable

List managed database columns

azure_sql_manageddatabaseschema.ManagedDatabaseColumns_ListByTable({
  "resourceGroupName": "",
  "managedInstanceName": "",
  "databaseName": "",
  "schemaName": "",
  "tableName": "",
  "subscriptionId": "",
  "api-version": ""
}, context)

Input

• input object
  • resourceGroupName required string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
  • managedInstanceName required string: The name of the managed instance.
  • databaseName required string: The name of the database.
  • schemaName required string: The name of the schema.
  • tableName required string: The name of the table.
  • $filter string: An OData filter expression that filters elements in the collection.
  • subscriptionId required string: The subscription ID that identifies an Azure subscription.
  • api-version required string: The API version to use for the request.

Output

• output DatabaseColumnListResult

ManagedDatabaseColumns_Get

Get managed database column

azure_sql_manageddatabaseschema.ManagedDatabaseColumns_Get({
  "resourceGroupName": "",
  "managedInstanceName": "",
  "databaseName": "",
  "schemaName": "",
  "tableName": "",
  "columnName": "",
  "subscriptionId": "",
  "api-version": ""
}, context)

Input

• input object
  • resourceGroupName required string: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
  • managedInstanceName required string: The name of the managed instance.
  • databaseName required string: The name of the database.
  • schemaName required string: The name of the schema.
  • tableName required string: The name of the table.
  • columnName required string: The name of the column.
  • subscriptionId required string: The subscription ID that identifies an Azure subscription.
  • api-version required string: The API version to use for the request.

Output

• output DatabaseColumn

Definitions

DatabaseColumn

• DatabaseColumn object: A database column resource.
  • properties DatabaseColumnProperties
  • id string: Resource ID.
  • name string: Resource name.
  • type string: Resource type.

DatabaseColumnListResult

• DatabaseColumnListResult object: A list of database columns.
  • nextLink string: Link to retrieve next page of results.
  • value array: Array of results.
    • items DatabaseColumn

DatabaseColumnProperties

• DatabaseColumnProperties object: Database column properties.
  • columnType string (values: image, text, uniqueidentifier, date, time, datetime2, datetimeoffset, tinyint, smallint, int, smalldatetime, real, money, datetime, float, sql_variant, ntext, bit, decimal, numeric, smallmoney, bigint, hierarchyid, geometry, geography, varbinary, varchar, binary, char, timestamp, nvarchar, nchar, xml, sysname): The column data type.

DatabaseSchema

• DatabaseSchema object: A database schema resource.
  • id string: Resource ID.
  • name string: Resource name.
  • type string: Resource type.

DatabaseSchemaListResult

• DatabaseSchemaListResult object: A list of database schemas.
  • nextLink string: Link to retrieve next page of results.
  • value array: Array of results.
    • items DatabaseSchema

DatabaseTable

• DatabaseTable object: A database table resource.
  • id string: Resource ID.
  • name string: Resource name.
  • type string: Resource type.

DatabaseTableListResult

• DatabaseTableListResult object: A list of database tables.
  • nextLink string: Link to retrieve next page of results.
  • value array: Array of results.
    • items DatabaseTable

ProxyResource

• ProxyResource object: ARM proxy resource.
  • id string: Resource ID.
  • name string: Resource name.
  • type string: Resource type.

Resource

• Resource object: ARM resource.
  • id string: Resource ID.
  • name string: Resource name.
  • type string: Resource type.