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

CodePudding user response:

It does not support such as devs explain:

Database creation doesn't support SQL Server (add as part of the # 810),

CodePudding user response:

You can like the following command to create the database:
- create the where
USE master;
GO
- check if the exists
IF DB_ID (N 'MyDatabaseTest) IS NULL
The DROP DATABASE MyOptionsTest;
GO
- the create database
The CREATE DATABASE MyDatabaseTest
COLLATE SQL_Latin1_General_CP1_CI_AS
WITH TRUSTWORTHY ON DB_CHAINING ON;
GO
- Verifying collation and option Settings.
SELECT the name, collation_name is_trustworthy_on, is_db_chaining_on
The FROM sys. Databases
WHERE name=N 'MyOptionsTest';
GO

If you want to delete the existing, use the following command:
IF DB_ID (N 'MyDatabaseTest') IS NOT NULL
The DROP DATABASE MyDatabaseTest;

CodePudding user response:

The building Lord now know how to create the Mssql database in DBeaver