title: How do I ensure about non negative column?
body: <p>I need to create a table <code>Branch</code> with columns <code>branch_name</code> and <code>branch_city</code> character type, <code>assets</code> as integer type. <code>branch_name</code> is the primary key and I have to ensure that <code>assets</code> are non negative.</p>
  
  <p>I tried like</p>
  
  <pre><code>CREATE TABLE Branch
  (
      branch_name navarchar(100) primary key,
      branch_city nvarchar(100),
      assests int NOT NULL
  )
  </code></pre>