Re: Null option and Default value Lost when use CREATE TABLE AS to backup a table.

On 10/21/21 7:47 AM, Xiao, Bing (Benny) wrote:
>
> 1. Create back up table.
>
> create table contact_bckp as table contacts with data;

This is not the correct way to do this. Do it this way instead:

BEGIN;
CREATE TABLE contact_bckp (LIKE contacts INCLUDING ALL);
INSERT INTO contact_bckp TABLE contacts;
COMMIT;
--
Vik Fearing