CODEWITHSUNDEEP
azureazure-sql-database
Janice
Janice

Reputation: 11

API or Service to fetch metadata of table in Azure SQL Database

I am trying to find an API or service to fetch the metadata of tables in Azure SQL database. However, I can't find anything. I only have an API that gets metadata of a database.

Upvotes: 0

Views: 427

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

There are no Azure ARM APIs for reading and writing from a database.

To read the metadata you must connect to the database with a SQL Server client and issue metadata queries, like

select *
from sys.tables

etc. You can easily do this with PowerShell, SQLCMD, or mssql-cli.

Upvotes: 1

Related Questions