How to add new tables to an existing Elastic Db


I have the need to add tables and stored procedures to existings shards, could anyone point me to the right direction on how to do this?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Anurag Sharma 17,581 Reputation points

    Hi @Emmanuel Toledo Sepulveda (US - IFS) , welcome to Microsoft Q&A forum.

    Adding table to database in elastic pool is same as we do in any azure Sql Database. We can use SSMS to connect to server and database and create any database objects. Please check the screenshots below:

    1) Connecting to database server:

    2) Creating tables or stored procedure:

    We can also use Azure Data Studio for the same.

    Please let us know if this helps or else we can discuss further.

    If answer helps, please mark it 'Accept Answer'

0 additional answers

Sort by: Most helpful