The DESCRIBE TABLE/VIEW is an excellent way of generating code for creating empty template tables/views.
Unfortunately, if you have used any other length than the default 8 for you numerical columns, that will not be reflected in the generated DDL.
So, make this perfect, let DESCRIBE generate LENGTH= for numerical columns.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.