Is anyone here who is willing to share a sql which will generate a 'create table..' script based on the existing table?
What I am trying to do is to maintain all storage paramentrs and rearrange the order of the columns in the table. The table is empty. No need to worry about data. My solution is to drop and re-create the table with a correct order of columns. I would generate a sql scipt for the existing table and change the columns around manually.