> For the complete documentation index, see [llms.txt](https://docs.snowddl.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.snowddl.com/guides/object-types.md). # Object types Object types are sorted in execution order. See explanation after the table.
Object typeCREATECOMPAREDROPNotes
ACCOUNT_PARAMETERN/AUNSAFE +N/AACCOUNTADMIN, skip on empty config
RESOURCE_MONITORUNSAFEUNSAFEUNSAFEACCOUNTADMIN
WAREHOUSESAFESAFESAFEACCOUNTADMIN to assign RESOURCE_MONITOR
WAREHOUSE_ROLESAFESAFESAFE
DATABASESAFEUNSAFEUNSAFE
SCHEMASAFEUNSAFEUNSAFE
SCHEMA_ROLESAFESAFESAFE
SECRETSAFESAFESAFE
NETWORK_RULESAFESAFE and UNSAFEUNSAFEALTER is safe, REPLACE is unsafe
EXTERNAL_ACCESS_INTEGRATIONSAFESAFESAFE
FILE_FORMATSAFESAFESAFEShort hash
STAGESAFESAFE and UNSAFEUNSAFE
SEQUENCESAFESAFEUNSAFE
FUNCTIONSAFESAFESAFEShort hash
EXTERNAL_FUNCTIONSAFESAFESAFEShort hash
PROCEDURESAFESAFESAFEShort hash
TABLESAFESAFE and UNSAFE +UNSAFE
EVENT_TABLESAFESAFE and UNSAFEUNSAFE
HYBRID_TABLESAFEUNSAFEUNSAFEShort hash
DYNAMIC_TABLESAFESAFE and UNSAFEUNSAFE
EXTERNAL_TABLESAFESAFESAFEShort hash
PRIMARY_KEYSAFESAFESAFE
UNIQUE_KEYSAFESAFESAFE
FOREIGN_KEYSAFESAFESAFE
MATERIALIZED_VIEWSAFEUNSAFEUNSAFE
VIEWSAFESAFESAFE
SEMANTIC_VIEWSAFESAFESAFEShort hash
PIPESAFEUNSAFEUNSAFEShort hash
STREAMSAFEUNSAFEUNSAFE
TASKSAFESAFESAFEShort hash
ALERTSAFESAFESAFE
SHARE (outbound)UNSAFE +UNSAFE +UNSAFE +
TECHNICAL_ROLESAFESAFESAFE
BUSINESS_ROLESAFESAFESAFE
USER_ROLESAFESAFESAFE
USERSAFEUNSAFEUNSAFE
AGGREGATION_POLICYUNSAFE +UNSAFE +UNSAFE +
AUTHENTICATION_POLICYUNSAFE +UNSAFE +UNSAFE +Short hash
JOIN_POLICYUNSAFE +UNSAFE +UNSAFE +
MASKING_POLICYUNSAFE +UNSAFE +UNSAFE +
NETWORK_POLICYUNSAFEUNSAFEUNSAFE
PROJECTION_POLICYUNSAFE +UNSAFE +UNSAFE +
ROW_ACCESS_POLICYUNSAFE +UNSAFE +UNSAFE +
BACKUP_POLICYUNSAFEUNSAFEUNSAFE
BACKUP_SETUNSAFEUNSAFEUNSAFE
### Notes * Safe & unsafe operations are explained in ["Safe & unsafe DDL" guide](/guides/other-guides/safe-unsafe.md). * Some role types are generated dynamically. You may read more in [Role hierarchy guide](/guides/role-hierarchy.md). * `+` means that additional setting or [CLI argument](/basic/cli.md) might be required to apply this change. * `ACCOUNTADMIN` note means that only user with this role can apply this change. It should be applied by human administrator manually or by SnowDDL user having this role automatically. * `Short hash` note means that objects of this type will have a short hash added to `comment`. It is explained in [Short hash guide](/guides/other-guides/short-hash.md). * In some cases both "safe" and "unsafe" changes can be applied to the same object type and operation type. Please refer to specific object type documentation for more details.