Cross-Schema Foreign Key not working with MSSQL about schemaspy HOT 5 CLOSED

#!/bin/bash

set -euo pipefail

name="mssql-schemaspy"
password="Passw0rd"

function clean_up {
	docker rm -f "$name"  > /dev/null 2>&1 || true
}

trap clean_up EXIT

function start_sql {
docker run -d \
		--name="$name" \
		-e ACCEPT_EULA="Y" \
		-e SA_PASSWORD="$password" \
	microsoft/mssql-server-linux:latest \
		> /dev/null
}

function exec_sql {
	docker run -i --rm \
			--net="container:${name}" \
			--entrypoint="sqlcmd" \
		tsgkadot/mssql-tools:latest \
			-d "${1-test}" -S 127.0.0.1 -U sa -P "$password"
}

function wait_for_sql {
	until is_ready > /dev/null; do
		sleep 1
	done
}

function is_ready {
	exec_sql master << EOF
SELECT state
FROM master.sys.databases
GO
EOF
}

function create_db {
	exec_sql master << EOF
CREATE DATABASE test
GO
EOF
}

function create_schemas {
	exec_sql << EOF
CREATE SCHEMA a
GO
CREATE SCHEMA b
GO
EOF
}

function create_tables {
	exec_sql << EOF
CREATE TABLE a.tbl_a (c int, PRIMARY KEY (c))
GO
CREATE TABLE b.tbl_b (c int, PRIMARY KEY (c), FOREIGN KEY (c) REFERENCES a.tbl_a(c))
GO
EOF
}

function schema_spy {
	docker run --rm --net="container:${name}" -v $(pwd):/build \
	    schemaspy:latest \
	    -t mssql05 \
	    -dp /opt/schemaspy/lib/sqljdbc4.jar \
	    -db test \
	    -host localhost \
	    -port 1433 \
	    -all \
	    -u sa \
	    -p "$password" \
	    -o /build
}

start_sql
wait_for_sql
create_db
create_schemas
create_tables
schema_spy