title: How does the stored procedure creations works in SQL Server?
body: <p>I am using SQL Server, I am confused whether we can write any random content inside the create statement or not.</p>
  <p>For example I have a database school. Inside that I have only one table students. I am trying to create SP like the below without including the column name beside select and it is throwing error while creating the sp.</p>
  <pre><code>Create procedure Getstud
  As
  Begin
  Select from Getstud
  End
  </code></pre>
  <p>I am not facing error while creating the below sp. But facing error while executing the sp as teachers table is not present.</p>
  <pre><code>Create procedure Getstud
  As
  Begin
  Select * from teachers
  End
  </code></pre>
  <p>Can anyone please help me understand this, does SQL Server check whether the tables, views ..etc present in the SP are actually correct (I am asking about the time when we are running the <code>create sp</code> not the <code>exec sp</code>)</p>