public void Show()
{
Helpers.ShowDataReaderContent(_connection, "show tables");
Helpers.ShowDataReaderContent(_connection, "show tablecolumns");
Helpers.ShowDataReaderContent(_connection, "show indexes");
Helpers.ShowDataReaderContent(_connection, "show indexcolumns");
Helpers.ShowDataReaderContent(_connection, "show views");
Helpers.ShowDataReaderContent(_connection, "show viewcolumns");
Helpers.ShowDataReaderContent(_connection, "show constraints");
Helpers.ShowDataReaderContent(_connection, "show checkconstraints");
Helpers.ShowDataReaderContent(_connection, "show constraintcolumns");
Helpers.ShowDataReaderContent(_connection, "show foreignKeyconstraints");
Helpers.ShowDataReaderContent(_connection, "show foreignKeys");
Helpers.ShowDataReaderContent(_connection, "show viewconstraints");
Helpers.ShowDataReaderContent(_connection, "show viewconstraintcolumns");
Helpers.ShowDataReaderContent(_connection, "show viewforeignkeys");
}
public void SelectStatement()
{
Helpers.ShowDataReaderContent(_connection, "select * from show tables");
}
public void ShowWithOrder()
{
Helpers.ShowDataReaderContent(_connection, "show indexes order by Name");
Helpers.ShowDataReaderContent(_connection, "show indexcolumns order by Index, Ordinal");
}
public void ShowWithWhereOrder()
{
Helpers.ShowDataReaderContent(_connection, "show indexes where Name like 'PK*' order by Name");
Helpers.ShowDataReaderContent(_connection, "show indexcolumns where index like 'PK*' order by Index, Ordinal");
}
public void ShowWithWhere()
{
Helpers.ShowDataReaderContent(_connection, "show indexes where Name like 'PK*'");
Helpers.ShowDataReaderContent(_connection, "show indexcolumns where index like 'PK*'");
}