Creating a table in an Azure SQL database

In this recipe, we will create a table in your Azure SQL database.

Getting ready

The prerequisites for this recipe are similar to the previous recipe, Connecting to an Azure SQL database. You must have the following:

  • A Windows Azure account
  • Azure PowerShell modules installed
  • An existing Azure SQL database
  • Azure subscription set up in your workstation
  • Firewall rules to allow your workstation to connect to your Azure database

To follow along, you need to note your Azure server name, database name, your username, and your password. You will need these when connecting to your instance in the recipe.

If you are not sure you have the prerequisites, I recommend that you go back to the previous recipe, Connecting to an ...

Get SQL Server 2014 with PowerShell v5 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.