Manage columns


When dynamic schema is enabled in your JavaScript backend mobile service, columns are added to a table by simply sending an insert request from your app that includes the new properties on the object. For more information, see the tutorial Get started with data (Windows Store C# / Windows Store JavaScript/HTML / Windows Phone / iOS / Android / HTML). You should disable dynamic schema when your app is in production.

For a .NET backend mobile service, the data model is defined in the Visual Studio project by using Code First in the Entity Framework. Changes are made to a published data model using Code First Migrations. For more information, see How to make data model changes to a .NET backend mobile service.

To manually create a new column in a JavaScript backend, simply click Add column, select a Data type, type a Column name, and then click the check button. The columns named with a "__" prefix are used by Microsoft Azure Mobile Services for system property columns. This prefix is reserved by Mobile Services for future use and should not be used with column names you add.

Once a column is created, its data type cannot be changed by Mobile Services. Insert or update operations fail when the type of a property in the JSON object cannot be converted to the type of the equivalent column in the table.

To delete columns, click the column and then click Delete.


When you delete a column, all data stored in that column is deleted. You should not delete system columns, which have a "__" prefix.

You can improve the performance of queries by having a well-defined index on the table. The table index should include any columns that are regularly used in queries, especially for filtering and sorting. To add a column to the index, select the column and click Set as Index.