title: Disable DELETE for a table in SQL Server
body: <p>I'm currently working on creating a table for customers in an order management system for a course at university. The system relies on being able to retrieve order histories for the customers.  Since we've chosen not to store these in a separate table, removing the option to delete rows from our customer table is essential.</p>
  
  <p>How and where do I set this up in the <code>CREATE</code> statement? I suspect I'll have to create a rule about what should happen instead, but I'm not entirely sure about the specifics.</p>