/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 vote144 views1 answer
Sql server remove primary key without dropping table
SQL
4 votes134 views3 answers
Check if two date ranges overlap sql server
SQL
9 votes119 views3 answers
Mysql show table column full description
SQL
3 votes114 views1 answer
Oracle APEX elapsed time
SQL
4 votes125 views1 answer
Oracle user tables
SQL
0 vote125 views2 answers
2nd max salary query in sql
SQL
1 vote117 views1 answer
Alter table column size oracle
SQL
0 vote160 views1 answer
Stop and start mysql
SQL
0 vote113 views1 answer
Complete date is 1 year or not sql server
SQL
20 votes132 views6 answers
Mysql reset auto increment
SQL