/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 vote292 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote311 views1 answer
Proc sql not in working
SQL
0 vote346 views1 answer
Postgres rename database
SQL
0 vote291 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote287 views1 answer
Login phpmyadmin without password
SQL
4 votes284 views2 answers
What is table in sql
SQL
9 votes312 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote302 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote272 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
5 votes303 views1 answer
Oracle nls instance
SQL