When you edit files in various formats every day, the universality of your document solution matters a lot. If your instruments work for only some of the popular formats, you might find yourself switching between software windows to copy table in WRI and handle other document formats. If you want to get rid of the headache of document editing, get a platform that can easily manage any format.
With DocHub, you do not need to concentrate on anything but actual document editing. You won’t have to juggle applications to work with different formats. It will help you revise your WRI as easily as any other format. Create WRI documents, modify, and share them in a single online editing platform that saves you time and improves your productivity. All you have to do is sign up a free account at DocHub, which takes just a few minutes or so.
You won’t need to become an editing multitasker with DocHub. Its functionality is enough for fast papers editing, regardless of the format you want to revise. Begin with creating a free account and discover how easy document management can be with a tool designed specifically to suit your needs.
today we will see how to copy the table w/o data to copy w/o data we will use 2 methods by generating script in 1st method we dont have to write the code in 2nd by writing code ok lets take this table to do the task TRN table in company db lets do it by 1st method select * from trn see this our table it contain a lot of data you can see here and i dont want to copy the data but only fields /structure , only fields fields name their data type etc.. see the table, these all are columns/fields so get the structure copy, w/o data this is our requirements so write the code, and by other way we generate script table created trn2018 company db already selected we do it within same db we creating trn2018 from trn second thing we will see, how to do the same thing to different db this query copy the data also you have to add here one condition only a intere sting one where 1=2 what does it mean 1=2 is not possible, ever then condition will be false so data will not be copied we use where co