Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2023 02:29 PM
Can I use SQL to create a table and set and expiration date? So that the table will be deleted automatically after the expiration date.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2023 04:30 PM
Not that I am aware of but you could create a job with a notebook task that runs a drop table <tablename> statement then set it to run on a trigger in the job when you want it to be deleted.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2023 05:10 PM
Right now it i not possible. You can always create a custom trigger solution with parameter to call notebook and delete the table.
