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?
Hi @EmmanuelToledoSepulvedaUSIFS-7914, 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'
11 people are following this question.