[2008] How does this work (installing app with SQL Database?)

Ok, I want to know how this works, I have a database in VS (several), now what happens when I build, and install my application via a project installer, do those databases get installed? or do I have to actually manually create the database in code, so it is created when my app is installed to someone's computer.

Thanks

If you've added an MDF file to your project and you're attaching that to SQL Server Express at run time then you just distribute the MDF.

If you have actually created a database in SQL Server then it's up to you to build that database when you install.

So, I need to create the database via code...

How would one check if a database exists, I saw nothing about that in my SQL tutorial.

Cheers