title: Azure SQL - Create table without schema?
body: <p>I am new to MS SQL Server, coming from MySQL.  I sort of understand MS SQL schemas and their purpose, but I don't see any need for them for small applications with the one DBA.</p>
  
  <p>Is it possible to ignore schemas altogether, for example to create and query tables?  If so what would be the format to create a table without specifying a schema?  This is in Azure, with an Azure SQL DB.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>Thanks to the answer below you don't apparently need to specify a schema when creating a table. Once created, the table will automatically have the schema 'dbo' applied by default.</p>
  
  <pre><code>CREATE TABLE cm_user
  (   
  cm_user_pk int PRIMARY KEY CLUSTERED, 
  user_code VARCHAR(10)  NOT NULL, 
  first_name VARCHAR(60)  NOT NULL,
  last_name    VARCHAR(60)  NOT NULL,
  email    VARCHAR(100)  NOT NULL,
  user_type    VARCHAR(20)  NOT NULL     
  ) 
  </code></pre>
  
  <p>results in the table <code>dbo.cm_user_pk</code></p>