/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 vote240 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote317 views1 answer
Oracle convert int to date
SQL
0 vote225 views1 answer
Get null value in sql
SQL
5 votes207 views1 answer
Oracle list days between two dates
SQL
0 vote177 views1 answer
Mysql server not starting in xampp in mac
SQL
1 vote189 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote192 views1 answer
Oracle webcenter content search enginer
SQL
0 vote193 views1 answer
Move table to a different schema
SQL
0 vote188 views2 answers
Mysql updating multiple column values from array variable
SQL
17 votes199 views3 answers
How to change a collumn name in sql
SQL