CODEWITHSUNDEEP
azure-mobile-services
tofutim
tofutim

Reputation: 23374

How do I set the schema for Azure Mobile App tables?

Currently tables get created in the "dbo" schema, but I would like to set it to something different. Is this possible?

Upvotes: 0

Views: 171

Answers (1)

Bruce Chen
Bruce Chen

Reputation: 18465

Currently tables get created in the "dbo" schema, but I would like to set it to something different. Is this possible?

For Node.js backend, you could add an app setting name MS_TableSchema with the value as your custom schema. You could log into Azure Portal and choose your app service, then click "All Settings > Application Settings", add the above setting under the App settings section. After created your new table via the Add button under "MOBILE > Easy tables" on Azure Portal, the new schema would be applied. For the existing table with the old schema, you may also need to alter your table with the newer schema. Moreover, you need to make sure your custom schema exists. Details you could follow this similar issue. Also, you could follow the Defining a Table section under TABLE CONTROLLER BASICS, and the Alternative Schema section under LINKING EXISTING TABLES.

For C# backend, you could follow adrian hall's book about Changing the Mobile Schema.

Upvotes: 1

Related Questions