Extract from a table to a dataset

Important

LOB and XML columns will not be extracted using this option. These column types will not appear on the template and existing SQL that contains these column types cannot be used to do a table extract. Since no data will be extracted for LOB and XML columns, a subsequent load using an extract file created with this option will not be successful if the table being loaded has LOB or XML columns that cannot be NULL.

This section provides information about the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*