/SQL/Create a sql server database programmatically

Create a sql server database programmatically

String str;
 SqlConnection myConn = new SqlConnection ("Server=localhost;Integrated security=SSPI;database=master");

str = "CREATE DATABASE MyDatabase ON PRIMARY " +
 "(NAME = MyDatabase_Data, " +
 "FILENAME = 'C:\\MyDatabaseData.mdf', " +
 "SIZE = 2MB, MAXSIZE = 10MB, FILEGROWTH = 10%)" +
 "LOG ON (NAME = MyDatabase_Log, " +
 "FILENAME = 'C:\\MyDatabaseLog.ldf', " +
 "SIZE = 1MB, " +
 "MAXSIZE = 5MB, " +
 "FILEGROWTH = 10%)";

SqlCommand myCommand = new SqlCommand(str, myConn);
try
{

Similar codes

38 votes352 views4 answers
Count sql
SQL
0 vote378 views1 answer
Oracle current date minus 1 day
SQL
1 vote356 views1 answer
Mysql decimal allow negative values?
SQL
0 vote346 views1 answer
List all functions and procedures in postgres query
SQL
0 vote357 views3 answers
Sql drop all tables
SQL
1 vote559 views2 answers
Sql unique rows
SQL
0 vote356 views1 answer
Where date in datetime mysql
SQL
16 votes346 views2 answers
Oracle ddl
SQL
0 vote361 views1 answer
Top frequency in sql server
SQL
0 vote368 views1 answer
Postgresql linux password
SQL