Top-Level Statements by Type

Standalone top-level SQL statements by type excluding nested statements that appear inside other statements (CREATE TABLE or INSERT inside CREATE PROCEDURE i.e.):

	Statement Type	Count	Conversion	Complexity	Lines	Need Conversion		Automated		Manual
1	Other DDL	1	Ok: 1 ✓	Undefined: 1	3	3	100.0%	3	100.0%	0	0.0%
2	Table	1	Check: 1 ! (1/1)	Undefined: 1	8	4	50.0%	4	100.0%	0	0.0%

Total: 2 distinct statement types, 2 occurrences.

All SQL Statements

Note that some statements can be nested within others (CREATE TABLE or INSERT inside CREATE PROCEDURE i.e. so issues, lines and other metrics cannot be summed):

	Statement	Description	Count	Conversion	Complexity	Lines	Need Conversion		Automated		Manual
1	ALTER TABLE	Alter table	1	Ok: 1 ✓	Undefined: 1	3	3	100.0%	3	100.0%	0	0.0%
2	CREATE TABLE	Create table	1	Check: 1 ! (1/1)	Undefined: 1	8	4	50.0%	4	100.0%	0	0.0%

Total: 2 distinct statements, 2 occurrences.

CREATE TABLE statements details:

	Details	Description	Count	Conversion
1	NOT NULL	NOT NULL constraint ^※	1	No Need: 1 ✓
2	NULL	NULL constraint ^※	4	No Need: 4 ✓
3	PRIMARY KEY	Primary key constraint	1	No Need: 1 ✓

ALTER TABLE statements details:

	Details	Description	Count	Conversion	Complexity
1	FOREIGN KEY	Foreign key constraint	1	No Need: 1 ✓

Data Types

All built-in data types:

	Source Data Type	Description	Count	Conversion	Complexity
1	DATETIME	Date and time with fraction	1	Check: 1 !	Undefined: 1
2	INTEGER	Integer number	2	No Need: 2 ✓
3	VARCHAR	Variable-length string	2	No Need: 2 ✓

Total: 3 distinct data types, 5 occurrences.

Built-in data type details:

	Source Data Type	Count
1	VARCHAR(<=255)	2

Total: 1 distinct data type specification, 2 occurrences.

Conversion Issues

Conversion issues that require review:

	Issue	Description	Count
1	DATETIME	Date and time with fraction	1

Total: 1 distinct conversion issue, 1 occurrence.