title: Can the constraint name be reused else were in the SQL query?
body: <p><img src="https://i.stack.imgur.com/I0EJo.png" alt="enter image description here"></p>
  
  <p>When creating a constraint can you use the name, in this case <code>checkChar</code>, for other values. What does having the name actually do anyway? Can it be reused elsewhere? </p>
  
  <p>Also, why does it give a "sort of error" if the values are the same in the column and then it will not let you change them (see below).</p>
  
  <p>Code:</p>
  
  <pre><code> CREATE TABLE EEE
   (
   FirstName  varchar (50)
   CONSTRAINT checkChar CHECK ([FirstName] LIKE '%[A-Za-z]%')
   )
  </code></pre>