## 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.):

Other DDL

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:10) */
    ALTERALTER - Alter table TABLETABLE - Alter table "dba"."ACTION_HISTORY"
        ADD FOREIGN KEY "FK3F3AF36B3E20AD51" ("USER_ID" ASC)
        REFERENCES "dba"."USERS" ("AUTO_ID");
    ALTERALTER - Alter table TABLETABLE - Alter table "ACTION_HISTORY"
        ADD FOREIGN KEY "FK3F3AF36B3E20AD51" ("USER_ID")
        REFERENCES "USERS" ("AUTO_ID");

Table

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:1) */
    CREATECREATE - Create table TABLETABLE - Create table "dba"."ACTION_HISTORY" (
        "ID"                             integer NOTNOT - NOT NULL constraint - No conversion needed. More... NULLNULL - NOT NULL constraint - No conversion needed. More... DEFAULT autoincrement
       ,"ACTION_TIME"                    "datetime" NULLNULL - NULL constraint - No conversion needed. More...
       ,"ACTION_NAME"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"DESCRIPTION"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"USER_ID"                        integer NULLNULL - NULL constraint - No conversion needed. More...
       ,PRIMARY KEY ("ID" ASC)
    );
    CREATECREATE - Create table TABLETABLE - Create table "ACTION_HISTORY" (
        "ID"                             integer NOTNOT - NOT NULL constraint - No conversion needed. More... NULLNULL - NOT NULL constraint - No conversion needed. More... GENERATED BY DEFAULT AS identity
       ,"ACTION_TIME"                    Timestamp NULLNULL - NULL constraint - No conversion needed. More...
       ,"ACTION_NAME"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"DESCRIPTION"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"USER_ID"                        integer NULLNULL - NULL constraint - No conversion needed. More...
       ,PRIMARY KEY ("ID")
    );

Table - Issues

| Filename:line | Source Code Snippet
1 | convert1.sql:3 |
    "datetime"

## 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):

ALTER TABLE - Alter table

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:10) */
    ALTERALTER - Alter table TABLETABLE - Alter table "dba"."ACTION_HISTORY"
        ADD FOREIGN KEY "FK3F3AF36B3E20AD51" ("USER_ID" ASC)
        REFERENCES "dba"."USERS" ("AUTO_ID");
    ALTERALTER - Alter table TABLETABLE - Alter table "ACTION_HISTORY"
        ADD FOREIGN KEY "FK3F3AF36B3E20AD51" ("USER_ID")
        REFERENCES "USERS" ("AUTO_ID");

CREATE TABLE - Create table

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:1) */
    CREATECREATE - Create table TABLETABLE - Create table "dba"."ACTION_HISTORY" (
        "ID"                             integer NOTNOT - NOT NULL constraint - No conversion needed. More... NULLNULL - NOT NULL constraint - No conversion needed. More... DEFAULT autoincrement
       ,"ACTION_TIME"                    "datetime" NULLNULL - NULL constraint - No conversion needed. More...
       ,"ACTION_NAME"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"DESCRIPTION"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"USER_ID"                        integer NULLNULL - NULL constraint - No conversion needed. More...
       ,PRIMARY KEY ("ID" ASC)
    );
    CREATECREATE - Create table TABLETABLE - Create table "ACTION_HISTORY" (
        "ID"                             integer NOTNOT - NOT NULL constraint - No conversion needed. More... NULLNULL - NOT NULL constraint - No conversion needed. More... GENERATED BY DEFAULT AS identity
       ,"ACTION_TIME"                    Timestamp NULLNULL - NULL constraint - No conversion needed. More...
       ,"ACTION_NAME"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"DESCRIPTION"                    varchar(255) NULLNULL - NULL constraint - No conversion needed. More...
       ,"USER_ID"                        integer NULLNULL - NULL constraint - No conversion needed. More...
       ,PRIMARY KEY ("ID")
    );

CREATE TABLE - Create table - Issues

| Filename:line | Source Code Snippet
1 | convert1.sql:3 |
    "datetime"

CREATE TABLE statements details:

NOT NULL - NOT NULL constraint

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:2) */
    NOTNOT - NOT NULL constraint - No conversion needed. More... NULLNULL - NOT NULL constraint - No conversion needed. More...
    NOTNOT - NOT NULL constraint - No conversion needed. More... NULLNULL - NOT NULL constraint - No conversion needed. More...

NULL - NULL constraint

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:3) */
    NULLNULL - NULL constraint - No conversion needed. More...
    NULLNULL - NULL constraint - No conversion needed. More...
2 |
    /* @SQLines(Filename - convert1.sql:4) */
    NULLNULL - NULL constraint - No conversion needed. More...
    NULLNULL - NULL constraint - No conversion needed. More...
3 |
    /* @SQLines(Filename - convert1.sql:5) */
    NULLNULL - NULL constraint - No conversion needed. More...
    NULLNULL - NULL constraint - No conversion needed. More...
4 |
    /* @SQLines(Filename - convert1.sql:6) */
    NULLNULL - NULL constraint - No conversion needed. More...
    NULLNULL - NULL constraint - No conversion needed. More...

PRIMARY KEY - Primary key constraint

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:7) */
    PRIMARY KEY ("ID" ASC)
    PRIMARY KEY ("ID")

ALTER TABLE statements details:

FOREIGN KEY - Foreign key constraint

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:11) */
    FOREIGN KEY "FK3F3AF36B3E20AD51" ("USER_ID" ASC)
        REFERENCES "dba"."USERS" ("AUTO_ID")
    FOREIGN KEY "FK3F3AF36B3E20AD51" ("USER_ID")
        REFERENCES "USERS" ("AUTO_ID")

## Data Types

All built-in data types:

DATETIME - Date and time with fraction

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:3) */
    "datetime"
    Timestamp

INTEGER - Integer number

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:2) */
    integer
    integer
2 |
    /* @SQLines(Filename - convert1.sql:6) */
    integer
    integer

VARCHAR - Variable-length string

| Source | Target
--- | --- | ---
1 |
    /* @SQLines(Filename - convert1.sql:4) */
    varchar(255)
    varchar(255)
2 |
    /* @SQLines(Filename - convert1.sql:5) */
    varchar(255)
    varchar(255)

Built-in data type details:

VARCHAR(<=255)

| Filename:line | Source Code Snippet
1 | convert1.sql:4 |
    varchar(255)
2 | convert1.sql:5 |
    varchar(255)

## Conversion Issues

Conversion issues that require review:

DATETIME - Date and time with fraction

| Filename:line | Source Code Snippet
1 | convert1.sql:3 |
    "datetime"