객체 수정하기
객체 수정하기 (ALTER **)
ALTER **
계정 수준 또는 데이터베이스 객체의 메타데이터나 세션의 매개변수를 수정해요.
함께 보기:
CREATE <object> , DESCRIBE <object> , SHOW <objects>
출처: 문서
본문
ALTER 명령
구체적인 구문, 사용 참고 사항, 예시는 다음을 참조하세요.
계정 및 세션 작업:
- ALTER ACCOUNT (계정 관리자만 해당)
- ALTER ORGANIZATION (조직 관리자만 해당)
- ALTER SESSION (모든 사용자)
계정 객체:
- ALTER APPLICATION
- ALTER APPLICATION PACKAGE
- ALTER APPLICATION PACKAGE ... RELEASE DIRECTIVE (Legacy)
- ALTER APPLICATION PACKAGE ... VERSION
- ALTER APPLICATION ROLE
- ALTER AUTHENTICATION POLICY
- ALTER CATALOG INTEGRATION
- ALTER COMPUTE POOL
- ALTER CONNECTION
- ALTER DATABASE
- ALTER DATABASE (catalog-linked)
- ALTER DATABASE ROLE
- ALTER DYNAMIC TABLE
- ALTER EXTERNAL ACCESS INTEGRATION
- ALTER EXTERNAL VOLUME
- ALTER FAILOVER GROUP
- ALTER FEATURE POLICY
- ALTER NETWORK POLICY
- ALTER NOTIFICATION INTEGRATION
- ALTER ORGANIZATION PROFILE
- ALTER POSTGRES INSTANCE
- ALTER REPLICATION GROUP
- ALTER RESOURCE MONITOR
- ALTER SECURITY INTEGRATION
- ALTER SHARE
- ALTER STORAGE INTEGRATION
- ALTER ROLE
- ALTER USER
- ALTER WAREHOUSE
데이터베이스 객체:
- ALTER AGENT
- ALTER AGGREGATION POLICY
- ALTER ALERT
- ALTER AUTHENTICATION POLICY
- ALTER BACKUP POLICY
- ALTER BACKUP SET
- ALTER CONTACT
- ALTER CORTEX SEARCH SERVICE
- ALTER DATA MOVEMENT POLICY
- ALTER DATA MOVEMENT RULE
- ALTER DATASET
- ALTER DATASET ... ADD VERSION
- ALTER DATASET ... DROP VERSION
- ALTER DBT PROJECT
- ALTER DCM PROJECT
- ALTER EXPERIMENT
- ALTER EXTERNAL AGENT
- ALTER EXTERNAL TABLE
- ALTER FILE FORMAT
- ALTER FUNCTION
- ALTER FUNCTION (DMF)
- ALTER GIT REPOSITORY
- ALTER ICEBERG TABLE
- ALTER JOIN POLICY
- ALTER LISTING
- ALTER MAINTENANCE POLICY
- ALTER MASKING POLICY
- ALTER MATERIALIZED VIEW
- ALTER MODEL
- ALTER MODEL ... ADD VERSION
- ALTER MODEL ... DROP VERSION
- ALTER MODEL ... MODIFY VERSION
- ALTER MODEL MONITOR
- ALTER NETWORK RULE
- ALTER NOTEBOOK
- ALTER OPENFLOW DATA PLANE
- ALTER ONLINE FEATURE TABLE
- ALTER PACKAGES POLICY
- ALTER PASSWORD POLICY
- ALTER PIPE
- ALTER PRIVACY POLICY
- ALTER PROCEDURE
- ALTER PROJECTION POLICY
- ALTER RESTRICTED SESSION SCOPE
- ALTER ROW ACCESS POLICY
- ALTER SCHEMA
- ALTER SECRET
- ALTER SEMANTIC VIEW
- ALTER SEQUENCE
- ALTER SERVICE
- ALTER SESSION POLICY
- ALTER SNAPSHOT
- ALTER SNAPSHOT POLICY — Deprecated (더 이상 사용되지 않음; ALTER BACKUP POLICY 사용을 권장합니다)
- ALTER SNAPSHOT SET — Deprecated (더 이상 사용되지 않음; ALTER BACKUP SET 사용을 권장합니다)
- ALTER STAGE
- ALTER STORAGE LIFECYCLE POLICY
- ALTER STREAM
- ALTER STREAMLIT
- ALTER TABLE
- ALTER TABLE (event tables)
- ALTER TAG
- ALTER TASK
- ALTER TYPE
- ALTER VIEW
클래스: