Teradata Database Message 9940 - 9940 - Analytics Database - Teradata Vantage
Analytics Database Messages
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 15.xx,16.xx,17.xx
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-01-05
- dita:mapPath
- sfx1628096178347.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-1096
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- Message
- SYSTEM VERSIONING cannot be dropped. The table has %VSTR.
- Explanation
- A temporal table has constraints (CHECK, UNIQUE, PRIMARY KEY or RI) or join index or trigger defined. The existing constraints or join index or triggers are associated with the temporal time dimension and hence SYSTEM VERSIONING cannot be dropped.
- Generated By
- OPD modules.
- For Whom
- End User.
- Notes
- None
- Remedy
- Drop the constraints and join indexes and triggers before DROP SYSTEM VERSIONING.