/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 vote245 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote224 views1 answer
How to find the most occuring in SQL
SQL
0 vote253 views1 answer
How to find total working hour in sql
SQL
0 vote251 views1 answer
Date 3 months from today sql
SQL
1 vote263 views1 answer
Sql how to replace full stop
SQL
4 votes226 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes234 views1 answer
Sql ends with string
SQL
16 votes253 views3 answers
Get count of duplicate records
SQL
0 vote221 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote238 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL