/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

9 votes593 views2 answers
Current date in postgresql minus 1 day
SQL
4 votes330 views1 answer
Adding data to table in sql python
SQL
0 vote356 views2 answers
Add new column after in sql
SQL
1 vote346 views1 answer
Tsql get beginning of year
SQL
7 votes387 views1 answer
Buy forge mods server hosting
SQL
1 vote325 views1 answer
Sql select table header
SQL
-1 vote351 views2 answers
Create temporary table sql
SQL
0 vote320 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote342 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
-1 vote305 views1 answer
How to format tables in sqlplus
SQL