%% Find Information About Table Types Using MySQL Native Interface
% Use a MySQL® native interface database connection to find information about all database table types in a MySQL database.
%
% Create a MySQL native interface database connection to a MySQL database.

datasource = "MySQLNative";
username = "root";
password = "matlab";

conn = mysql(datasource,username,password);

%
% Find information about all table types in the database.

data = sqlfind(conn,"");

% Display information about the first three table types.

head(data,3)

% data contains these variables:
% Catalog name
% Schema name
% Table name
% Columns in the table type
% Table type
%
% Close the database connection.

close(conn)

% Copyright 2020 The MathWorks, Inc.