/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

2 votes277 views1 answer
Oracle calculated column
SQL
7 votes277 views2 answers
Sql empty table
SQL
5 votes257 views1 answer
List foreign key oracle
SQL
0 vote266 views1 answer
Oracle create package specification
SQL
18 votes270 views3 answers
Mysql add column with default value
SQL
0 vote305 views2 answers
Coursera spark sql max count
SQL
0 vote300 views1 answer
PostgreSQL types and C# types
SQL
0 vote259 views1 answer
How to check which sp is running in sql server
SQL
6 votes292 views2 answers
How to get yesterday date in mysql
SQL
3 votes299 views2 answers
Savepoint in sql
SQL