%% Retrieve Default Import Options for Database Columns Using Numeric Index
% Control the import options by creating an SQLImportOptions object. Then, retrieve the default import options for several columns from a database table. Specify the columns to retrieve by using a numeric index.
% This example uses the patients.xls spreadsheet, which contains the columns LastName, Gender, and Age. Also, the example uses a Microsoft® SQL Server® Version 11.00.2100 database and the Microsoft SQL Server Driver 11.00.5058.
%
% Create a database connection to a Microsoft SQL Server database with Windows® authentication. Specify a blank user name and password.

datasource = 'MS SQL Server Auth';
conn = database(datasource,'','');

%
% Load patient information into the MATLAB® workspace.

patients = readtable('patients.xls');

% Create the patients database table using the patient information.

tablename = 'patients';
sqlwrite(conn,tablename,patients)

%
% Create an SQLImportOptions object using the patients database table and the databaseImportOptions function.

opts = databaseImportOptions(conn,tablename);

%
% Specify the first three database columns by using a numeric index.

index = [1,2,3];

% Retrieve and display the default import options for the specified database columns.

varOpts = getoptions(opts,index)

% To modify the variable import options, see the setoptions function.
%
% Delete the patients database table using the execute function.

sqlquery = ['DROP TABLE ' tablename];
execute(conn,sqlquery)

% Close the database connection.

close(conn)

% Copyright 2018 The MathWorks, Inc.