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 | Table | 1 | Check: 1 ! (1/1) | Undefined: 1 | 8 | 4 | 50.0% | 4 | 100.0% | 0 | 0.0% |
Total: 1 distinct statement type, 1 occurrence.
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 | CREATE TABLE | Create table | 1 | Check: 1 ! (1/1) | Undefined: 1 | 8 | 4 | 50.0% | 4 | 100.0% | 0 | 0.0% |
Total: 1 distinct statement, 1 occurrence.
CREATE TABLE statements details:
| Details | Description | Count | Conversion | Complexity | |
|---|---|---|---|---|---|
| 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 ✓ |
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 that require review:
| Issue | Description | Count | |
|---|---|---|---|
| 1 | DATETIME | Date and time with fraction | 1 |
Total: 1 distinct conversion issue, 1 occurrence.