Error in table

I tried to create a table name Apps in the Movies database but don't know where it goes. Can you please help me out?
Who is Participating?
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
It's being created against the [master] database. Notice that [master] has been selected at the top left drop-down in SSMS.

Generally, the recommendation would be to have a USE statement that changes the database context at the start of a script so that you know the specific database where the script will be executed against. The USE statement looks like:
USE [Movies]

Open in new window

USE is probably the simplest method.  But FWIW, you can also specify the database name in the CREATE TABLE statement

CREATE TABLE DatabaseName.schemaname.TableName ( ..... )

Open in new window

  • DatabaseName = "Movies"
  • SchemaName = Whatever you want, but defaults to "dbo"
  • TableName = "Apps"


CREATE TABLE Movies.dbo.Apps ( AppID int, /* more column definitions here */ )

Open in new window

mustish1Author Commented:
Thank You.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.