3.0.0 • Published 5 years ago
@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.
- resourceGroupName required
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.
- resourceGroupName required
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.
- resourceGroupName required
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.
- resourceGroupName required
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.
- resourceGroupName required
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.
- resourceGroupName required
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
- nextLink
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.
- columnType
DatabaseSchema
- DatabaseSchema
object
: A database schema resource.- id
string
: Resource ID. - name
string
: Resource name. - type
string
: Resource type.
- id
DatabaseSchemaListResult
- DatabaseSchemaListResult
object
: A list of database schemas.- nextLink
string
: Link to retrieve next page of results. - value
array
: Array of results.- items DatabaseSchema
- nextLink
DatabaseTable
- DatabaseTable
object
: A database table resource.- id
string
: Resource ID. - name
string
: Resource name. - type
string
: Resource type.
- id
DatabaseTableListResult
- DatabaseTableListResult
object
: A list of database tables.- nextLink
string
: Link to retrieve next page of results. - value
array
: Array of results.- items DatabaseTable
- nextLink
ProxyResource
- ProxyResource
object
: ARM proxy resource.- id
string
: Resource ID. - name
string
: Resource name. - type
string
: Resource type.
- id
Resource
- Resource
object
: ARM resource.- id
string
: Resource ID. - name
string
: Resource name. - type
string
: Resource type.
- id
3.0.0
5 years ago