/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

17 votes225 views6 answers
Current date in sql
SQL
0 vote216 views1 answer
Sql insert from excel
SQL
1 vote340 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote205 views1 answer
Install mysql 8 linux
SQL
2 votes224 views2 answers
Created at and updated at in mysql
SQL
5 votes225 views1 answer
Sort order on two columns sql
SQL
13 votes220 views6 answers
Restart postgresql
SQL
9 votes248 views3 answers
Pyodbc connect to sql server
SQL
1 vote253 views1 answer
Db.Database.SqlQuery
SQL
4 votes207 views1 answer
Mac install mysql
SQL