Schema under Database on Azure

Question

Can we create different schema's under SQL Database on Azure???? Also what is the limit in terms of number of schema's per database on Azure (IAAS, PAAS, MI)

Answer 1

Yes, you can create user-defined schemas with Azure SQL Database similarly to the other SQL Server platforms. AFAIK, there is no practical limit to the number of schemas; it's limited by the maximum int value (2,147,483,647).

---

Dan Guzman, Data Platform MVP, http://www.dbdelta.com

Answer 2

Just checking in to see if the above answer(s) helped.

 

If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

And, if you have any further queries do let us know.