question

I don't understand the question. AdventureWorks2012 is a user database. Attaching it will create a new user database. The master database will have a reference to the new database in the system view sys.databases. But creating/attaching a user database won't create any new objects in the master database.

Note: This is my first time posting a question (on this site) and then responding to the answers. I'd welcome guidance site admins, if I've put this follow-up question in an inconvenient place. Hi Magnus and Grant, I do see the attached objects (AdventureWorks2012) in the Object Explorer. Because I'm using "best practices" in developing new scripts, I'd like to use expressions like: IF object_ID (N'SomeAdventureWorks2012Object') IS NOT NULL / DROP someObjectType SomeAdventureWorkds2012Object. So, how do I get SQL Server to "recognize" these AdventureWork2012 objects with Object_ID function?

When responding to a comment or an answer, use the "Add New Comment" button below the comment or the Answer. The "Your answer" box is for posting a possible answer to the question above. If you're going to query for object_id from the master database, then you have to use three part naming, database.schema.object. There are examples here in the object_id entry of the SQL Server documentation: https://msdn.microsoft.com/en-us/library/ms190328.aspx If you are in the AdventureWorks database, you only need to use two part naming, schema.object.