ON [PRIMARY] 是什么意思?

2021-12-26 00:00:00 sql database sql-server database-design

我正在创建一个 SQL 安装脚本，并以其他人的脚本为例.这是脚本的示例:

I'm creating an SQL setup script and I'm using someone else's script as an example. Here's an example of the script:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[be_Categories](
    [CategoryID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_be_Categories_CategoryID]  DEFAULT (newid()),
    [CategoryName] [nvarchar](50) NULL,
    [Description] [nvarchar](200) NULL,
    [ParentID] [uniqueidentifier] NULL,
 CONSTRAINT [PK_be_Categories] PRIMARY KEY CLUSTERED 
(
    [CategoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

有人知道 ON [PRIMARY] 命令的作用吗?

Does anyone know what the ON [PRIMARY] command does?

推荐答案

在 Microsoft SQL Server 中创建数据库时，您可以拥有多个文件组，其中在多个位置、目录或磁盘中创建存储.每个文件组都可以命名.PRIMARY 文件组是默认的，它总是被创建，因此您提供的 SQL 在 PRIMARY 文件组上创建您的表.

When you create a database in Microsoft SQL Server you can have multiple file groups, where storage is created in multiple places, directories or disks. Each file group can be named. The PRIMARY file group is the default one, which is always created, and so the SQL you've given creates your table ON the PRIMARY file group.

请参阅 MSDN完整的语法.

相关文章