Create a table
Updated: June 16, 2015
Before you can use Microsoft Azure Mobile Services to store app data, you must create at least one storage table in the Microsoft Azure SQL Database associated with the mobile service instance. When you complete the quick start, you have a table named Todoitem in your database.
Each table must have a unique name within the scope of the mobile service. The table in the SQL Database is created with a schema name that matches your mobile service name.
Everyone: This means that any request for the operation against the table is accepted. This option leaves your data wide-open for everyone to access.
Anybody with the Application Key: The application key is required to perform the operation. The application key is distributed with the application. Because this key is not securely distributed, it cannot be considered a security token. To secure access to your mobile service data, you must instead authenticate users before accessing.
Only Scripts and Admins: The operation requires the service master key, which limits the operation only to registered scripts or to administrator accounts.
To add a table to a .NET backend, you just add a new property to the Code First data model that returns a DbSet based on a new model data type that inherits from the EntityData type. For more information, see How to make data model changes to a .NET backend mobile service
The following columns are added in the database to every table created by Mobile Services:
The columns named with a "__" prefix are used by nextref_zumo for system property columns. For more information, see System columns.