For Splice Machine Tutorial Video – Creating scripts to run SQL commands

setup_scripts.sql

--to run this script from splice prompt:
-- splice> run '/<path>/<to>/<script>/setup_scripts.sql';

--create schema
create schema script;

-- set schema
set schema script;

--create table
create table DOMAIN_DATA (
	sex_code char(1),
	gender varchar(100)
	);

insert into DOMAIN_DATA(sex_code, gender) values ('F', 'Female');
insert into DOMAIN_DATA(sex_code, gender) values ('U', 'Unknown');
insert into DOMAIN_DATA(sex_code, gender) values ('M', 'Male');