Object Already Exists When Creating Object (T-SQL)

What happens when we run into the problem where a table already exists in our database when we try to create one? Check out the solution in the video There is already an object named '' in the database (Table Creation). As you can see, we generate this error and step through what it means in a few contexts - one text where the error occurs and the other context in which we see results in no errors.

Some questions answered in the vidoe:

• How do we check if exists?
• What are the different ways we discuss to create the tables in the video?
• On creation, what differs between variable and temp table creation?

As a general rule, we may not want to give users the permission to create tables outside of temp tables (the latter being allowed if they have data reader access). We may even be more granular than this and only give users the permission to access a specific object. While we look at ways to get around this error, we want to be careful about security in this context as well.