Android Question SQLITE - is typeof column unique?

Dim rs As ResultSet
    rs = Starter.SQL1.ExecQuery("SELECT * FROM sqlite_master")
    Do While rs.NextRow        
        Dim str As String = $"
        ${rs.getstring("sql")}"$
        LogColor(str, Colors.Magenta)
        'example of what the log displays: CREATE TABLE tblVehicles (Make int unique not null, Model INTEGER, P_DATE TEXT )

'        Dim str As String = $"${rs.getstring("tbl_name")}
'        ${rs.getstring("name")} 
'        ${rs.getstring("type")}
'        ${rs.getstring("sql")}"$
'        LogColor(str, Colors.Magenta)
    Loop
    rs.close

Sub check_unique( strTable As String, strColumn As String) as Boolean
    Dim ddl As String
    Dim isUnique As Boolean = False
     
    'Get table DDL
    ddl = Main.SQ.ExecQuerySingleResult($"SELECT sql FROM sqlite_master WHERE type = 'table' AND tbl_name = '${strTable}'"$)
 
    'Clean up brackets, opening parenthesis and replacing closing parenthesis with a comma
    ddl = ddl.SubString(ddl.IndexOf("(")+1).Replace(")",",").Replace("[","").Replace("]","")

    'extracts the desired field definiion from DDL and check if it contains the UNIQUE clause
    ddl = ddl.SubString(ddl.IndexOf(strColumn))
    ddl = ddl.SubString2(0, ddl.IndexOf(","))
    If ddl.Contains("UNIQUE") Then
        isUnique=True
    End If

    Return isUnique
 
End Sub

CREATE TABLE [TEST](
  [TEST1] INTEGER CONSTRAINT [UC_TEST1] UNIQUE,
  [TEST2] TEXT,
  [TEST3] DATE CONSTRAINT [UC_TEST3] UNIQUE,
  CONSTRAINT [UC_TEST2] UNIQUE([TEST2]) ON CONFLICT FAIL);

ddl = ddl.SubString(ddl.IndexOf(strColumn))
    ddl = ddl.SubString2(0, ddl.IndexOf(","))
    ddl=ddl.ToUpperCase   '<----  Add this
    If ddl.Contains("UNIQUE") Then
        isUnique=True
    End If
    Return isUnique