/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

1 vote134 views1 answer
Oracle update with sequence
SQL
0 vote153 views1 answer
Inner join distinct
SQL
0 vote132 views1 answer
Vbscript connect mssql
SQL
0 vote125 views1 answer
Oracle query archivemode
SQL
0 vote127 views1 answer
Sql count * vs count 1
SQL
5 votes122 views1 answer
Minecraft java port number
SQL
-1 vote140 views1 answer
Spring boot mysql connection properties
SQL
0 vote124 views1 answer
How to find username and password in oracle 18c
SQL
0 vote127 views1 answer
Create synonym for dblink in oracle
SQL
0 vote145 views1 answer
Mysql get nth highest
SQL