/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

0 vote261 views1 answer
Cast float mysql
SQL
6 votes323 views2 answers
Oracle compile trigger
SQL
2 votes279 views1 answer
Sql OR
SQL
5 votes271 views3 answers
Oracle first day of last year
SQL
0 vote278 views1 answer
Change filed order in mysql
SQL
0 vote249 views1 answer
How to save data in database in mysql node
SQL
1 vote276 views1 answer
How to use db.execute
SQL
0 vote272 views1 answer
Oracle cpu metric
SQL
1 vote270 views1 answer
Simple project for database
SQL
0 vote293 views1 answer
Mysql date without time
SQL