/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 vote111 views1 answer
Normalization in database
SQL
6 votes113 views3 answers
Mysql remove user privileges
SQL
0 vote147 views1 answer
Creating sqeuence in oracle database
SQL
0 vote111 views1 answer
Mysql update from n to 100
SQL
5 votes112 views1 answer
Oracle nls parameters
SQL
3 votes110 views4 answers
Show databases in sql server
SQL
0 vote110 views1 answer
How to check common records in 2 table
SQL
0 vote114 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote116 views1 answer
Mysql show create db
SQL
0 vote108 views4 answers
How to connect form to database
SQL