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

Table

SourceTarget
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:lineSource Code Snippet
1convert1.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):

CREATE TABLE - Create table

SourceTarget
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:lineSource Code Snippet
1convert1.sql:3
"datetime"

CREATE TABLE statements details:

NOT NULL - NOT NULL constraint

SourceTarget
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

SourceTarget
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

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

Data Types

All built-in data types:

DATETIME - Date and time with fraction

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

INTEGER - Integer number

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

VARCHAR - Variable-length string

SourceTarget
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:lineSource Code Snippet
1convert1.sql:4
varchar(255)
2convert1.sql:5
varchar(255)

Conversion Issues

Conversion issues that require review:

DATETIME - Date and time with fraction

Filename:lineSource Code Snippet
1convert1.sql:3
"datetime"