Make External List From Sql Azure Table. Make an External List from a SQL Azure table with Business Connectivity Services and Secure Store Step 1. Returns all external tables in the database or a specific external table.
Regards Shalini Hi Shalini You can do it using following queries. Schema_name. SELECT FROM SCHEMAEXTERNAL_TABLE_LINK.
Hi Are there any queries to identifylist the external data sources and external tables created in Azure DB.
To create the External List in the SharePoint site select OK and then select Save. Create and alter tables in Azure Storage or Azure Data Lake. This is expected since the External table does not define the new column and hence did not include that column in the SELECT statement. Creates an external table for PolyBase or Elastic Database queries.