CREATE SCHEMA `test_schema`;

CREATE TABLE `test_schema`.`alpha` (
  `id` INT NOT NULL ,
  PRIMARY KEY (`id`) );

CREATE TABLE `test_schema`.`bravo` (
  `id` INT NOT NULL ,
  PRIMARY KEY (`id`) );

CREATE TABLE `test_schema`.`charlie` (
  `id` INT NOT NULL ,
  PRIMARY KEY (`id`) );

CREATE TABLE `test_schema`.`delta` (
  `id` INT NOT NULL ,
  PRIMARY KEY (`id`) );

CREATE TABLE `test_schema`.`echo` (
  `id` INT NOT NULL ,
  PRIMARY KEY (`id`) );

SELECT * FROM `test_schema`.`charlie`;