/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 vote259 views1 answer
Mysql get longest string in column
SQL
0 vote205 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote202 views1 answer
Odd record sql query
SQL
0 vote198 views1 answer
Mysql grant grant option
SQL
0 vote198 views1 answer
Sql server select ignore dupplicates
SQL
0 vote197 views2 answers
Sql drop view if exists
SQL
0 vote195 views2 answers
How to save result of sqlite query in a table
SQL
8 votes199 views2 answers
Alert table name mysql
SQL
0 vote197 views1 answer
Xampp increame mysql speed
SQL
0 vote219 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL