title: Microsoft SQL Server Management Studio, Is it possible to see the code behind design view?
body: <p>I tried googling but had no luck finding the answer,</p>
  
  <p>I'm using Microsoft SQL Server 2008 Server management server and was wondering if you could use the design view to create the table and then look at the get the code/(query?) behind it?</p>
  
  <p><img src="https://i.stack.imgur.com/B3cge.png" alt="enter image description here"></p>
  
  <p>e.g. Going from ^ To:</p>
  
  <pre><code>CREATE TABLE Member (
  MemberNo VARCHAR(8) NOT NULL PRIMARY KEY,
  MemberTypeNo INT NOT NULL FOREIGN KEY (MemberTypeNo) REFERENCES MemberTypeNo (MemberType),        
  FirstName VARCHAR(15) NOT NULL, 
  LastName VARCHAR(15),
  DateOfBirth DATE,
  )
  </code></pre>
  
  <p><strong>------------------------------------------------------------------------------------------------------------------------------------</strong></p>
  
  <p><strong>UPDATE: Solution as described by @Jeff Hornby</strong></p>
  
  <p><img src="https://i.stack.imgur.com/YXaNz.png" alt="enter image description here"></p>