title: Drop foreign key without knowing the name of the constraint?
body: <p>I have created one table using the below command:</p>
  <pre><code>create table Table1(
      Id int Not Null 
          Foreign key 
          references Table2(Id)  
          on delete cascade 
          on update cascade,
      UserName nvarchar(150),
      TimeInSeconds int Not Null 
  
      primary key(Id,TimeInSeconds)
  );
  </code></pre>
  <p>But now I want to drop the foreign key.
  As I haven't given a constraint name, I can't use:</p>
  <pre><code>Alter table &lt;tablename&gt;
  drop foreign key &lt;foreign key name&gt;
  </code></pre>
  <p>Is there any way?</p>