sql server - How to Run a Script against a Local Database? -

sql server - How to Run a Script against a Local Database? -

vs 2010 has got new item called local database enables have database file, .sdf, without installing sql server locally.

i have sql script containing ddl scripts, such create table, etc, when run against database, opening new query info connection in visual studio, gives me below error:

the create table sql build or statement not supported.

how run script against local database without having sql server installed?

it should supported:

http://msdn.microsoft.com/en-us/library/ms173393(v=sql.100).aspx

alternate option:

if install ssms (express), can bring new connection, , under "server type", there sec alternative called "sql server compact".

http://www.microsoft.com/en-us/download/details.aspx?id=22985

sql-server visual-studio-2010 visual-studio tsql table