1. SQL Management Studio Fails to Recognize Scripted Table Creation

This fails saying that States doesn’t exist. Also States doesn’t show up in the intellisense. What should I do to: Ctrl + Shift + R

2. How to Create a Schema (Instead of dbo)

First, navigate to “Security” in the database and select “New Schema.”

Then, change the text and click “OK.”

3. How to Automatically Generate a New GUID:

Just click on the property for the ID, and then add newsequentialid() or newid(). That’s it!