tencent cloud

TDSQL Boundless

sql_require_primary_key

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-03-27 17:53:35

Feature Description

This parameter is used to enforce that tables must contain a primary key and prevent the primary key from being accidentally removed. When set to ON, all newly created tables must define a primary key, and existing primary keys cannot be removed via ALTER TABLE statements. Attempts to violate these rules will result in an error.

Attribute Description

Required
Description
Parameter Type
BOOL
Default Value
OFF
Value Range
OFF
ON
Effective Scope
GLOBAL
SESSION
Restart Required
No

Ajuda e Suporte

Esta página foi útil?

comentários