Copy and Paste Tables/Databases/Functions/Views
You already present an option to clone table. You already know how to step over the whole a whole database. You already know how to read a view. you already know how to read a function.
You also know how to create tables, views, triggers, databases.
You also know how to read columns.
From your clone table feature you normally add '_copy' on the end to avoid conflicting names.
So when a users selects copy, store what it is they want to copy (a ref to a type of object and what the object is)
when they click paste, step over what ever the object was (so a database would be a lot of work to step over, a function would just be one object) then use the create syntax to create it in the destination.
Im not 100% on the technical data of copying data, but maybe a select insert?
Please login to leave a reply, or register at first.