/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 vote213 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote175 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote195 views1 answer
How to print some string in mysql
SQL
0 vote174 views1 answer
How to find all children of a record with only parent ID in sql
SQL
3 votes191 views2 answers
How to force truncate a table in mysql
SQL
0 vote171 views1 answer
Postgresql not in alternative
SQL
0 vote154 views1 answer
Call procedure in wordpress
SQL
0 vote173 views1 answer
Java nosql sort
SQL
0 vote129 views2 answers
Jupyter notebook connect to database
SQL
0 vote160 views1 answer
How to count with except in psql
SQL