sql - AWS MS SQL 创建表

Question

我已按照本指南创建了一个 AWS MS SQL 数据库

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.SQLServer.html#CHAP_GettingStarted.Connecting.SQLServer

我可以连接到它并使用命令

Select @@VERSION 

但是，当我尝试创建表时出现错误

Msg 262, Level 14, State 1, Line 1 CREATE TABLE permission denied in database 'master'.

我尝试的命令是

CREATE TABLE [RawInput] (
  [DateTime] datetime,
  [Text] text,
  PRIMARY KEY ([DateTime])
);

Answer 1

分辨率:

USE [YOUR_DATABASE]

原因

什么是master数据库:

取自链接:https://learn.microsoft.com/en-us/sql/relational-databases/databases/master-database?view=sql-server-2017

The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings. In SQL Server, system objects are no longer stored in the master database; instead, they are stored in the Resource database. Also, master is the database that records the existence of all other databases and the location of those database files and records the initialization information for SQL Server. Therefore, SQL Server cannot start if the master database is unavailable.

任何用户级查询都不能使用 master 数据库运行，因为它会跟踪所有其他数据库