When to use the managed table and the external table? Is there any particulars to create those tables?
Could you explain the question a little better?
When should we use the external and internal tables ?
@nikhil23 Its all depends upon the use case. I meant that if you want to retain the underlying the data even though you drop the table (i.e including the metadata) then “External Table” is a choice else “Internal Table” because when you drop an internal table then it will delete the underlying data including metadata.
Thanks for the help sir