title: How to know if 'contained database authentication' is turned on in SQL Azure?
body: <p>Is there a query I can run to know if '<em>contained database authentication</em>' is turned on in a user-defined database in SQL Azure or SQL Server 2014?</p>
  
  <p>I tried the following query but it does have a column for 'contained database authentication'?</p>
  
  <pre><code>select *  from   sys.databases 
  where name='myDatbase';
  </code></pre>