How to create a SQL Server database using dBeaver?

Question

How to create a database in SQL Server 2014 using the dBeaver GUI tool?

Answer 1

It isn't supported yet, as devs explain:

Database create not yet supported for SQL Server (will be added as a part of #810).

Answer 2

You can create database by commands like below:

--create where
USE master;  
GO
--check if exists
IF DB_ID (N'MyDatabaseTest') IS NULL  
DROP DATABASE MyOptionsTest;  
GO 
--create database 
CREATE DATABASE MyDatabaseTest  
COLLATE SQL_Latin1_General_CP1_CI_AS  
WITH TRUSTWORTHY ON, DB_CHAINING ON;  
GO
--Verifying collation and option settings.  
SELECT name, collation_name, is_trustworthy_on, is_db_chaining_on  
FROM sys.databases  
WHERE name = N'MyOptionsTest';  
GO 

If you want to delete existing one, use below command:

IF DB_ID (N'MyDatabaseTest') IS NOT NULL  
DROP DATABASE MyDatabaseTest;