/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 votes176 views2 answers
Storing timezones in postgres
SQL
0 vote160 views1 answer
What is between keyword used for
SQL
0 vote174 views1 answer
View to table sql
SQL
0 vote147 views1 answer
How to to get current date and time in sql
SQL
0 vote161 views1 answer
Less than date query sqlachemy
SQL
0 vote147 views1 answer
Select all tables linked server sql
SQL
8 votes173 views2 answers
Grant all privileges database postgres to user
SQL
0 vote182 views1 answer
Oracle step procedure
SQL
0 vote161 views1 answer
Sql select where more than one record exists
SQL
3 votes142 views2 answers
Pl sql escape '
SQL