select FullName from tables
PartsSupplier.PARTSSUPPLIER.PARTS
PartsSupplier.PARTSSUPPLIER.SHIP_VIA
PartsSupplier.PARTSSUPPLIER.STATUS
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS
PartsSupplier.PARTSSUPPLIER.SUPPLIER

select Cardinality from tables
16
4
3
227
16

select supportsUpdate from tables
true
true
true
true
true

select FullName from columns
PartsSupplier.PARTSSUPPLIER.PARTS.PART_COLOR
PartsSupplier.PARTSSUPPLIER.PARTS.PART_ID
PartsSupplier.PARTSSUPPLIER.PARTS.PART_NAME
PartsSupplier.PARTSSUPPLIER.PARTS.PART_WEIGHT
PartsSupplier.PARTSSUPPLIER.SHIP_VIA.SHIPPER_ID
PartsSupplier.PARTSSUPPLIER.SHIP_VIA.SHIPPER_NAME
PartsSupplier.PARTSSUPPLIER.STATUS.STATUS_ID
PartsSupplier.PARTSSUPPLIER.STATUS.STATUS_NAME
PartsSupplier.PARTSSUPPLIER.SUPPLIER.SUPPLIER_CITY
PartsSupplier.PARTSSUPPLIER.SUPPLIER.SUPPLIER_ID
PartsSupplier.PARTSSUPPLIER.SUPPLIER.SUPPLIER_NAME
PartsSupplier.PARTSSUPPLIER.SUPPLIER.SUPPLIER_STATE
PartsSupplier.PARTSSUPPLIER.SUPPLIER.SUPPLIER_STATUS
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS.PART_ID
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS.QUANTITY
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS.SHIPPER_ID
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS.SUPPLIER_ID

select FullName, supportsUpdate from tables
PartsSupplier.PARTSSUPPLIER.PARTS	true
PartsSupplier.PARTSSUPPLIER.SHIP_VIA	true
PartsSupplier.PARTSSUPPLIER.STATUS	true
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS	true
PartsSupplier.PARTSSUPPLIER.SUPPLIER	true

select FullName from models
PartsSupplier

select FullName from models
PartsSupplier

select MaxSetSize from models
100

select FullName, supportsUpdate from tables where FullName='PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS'
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS	true

select FullName, supportsUpdate from tables where FullName='PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS' and Cardinality=227 and supportsUpdate = 'true'
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS	true

select * from foreignKeys
PartsSupplier.PARTSSUPPLIER.SUPPLIER.FK_SPLIER_STATS
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS.FK_SPLIER_PRTS_PRTS
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS.FK_SPLY_PRTS_SPLY

select * from primaryKeys
PartsSupplier.PARTSSUPPLIER.PARTS.PK_PARTS
PartsSupplier.PARTSSUPPLIER.SHIP_VIA.PK_SHIP_VIA
PartsSupplier.PARTSSUPPLIER.STATUS.PK_STATUS
PartsSupplier.PARTSSUPPLIER.SUPPLIER.PK_SUPPLIER
PartsSupplier.PARTSSUPPLIER.SUPPLIER_PARTS.PK_SUPPLIER_PARTS

select UPPER(FullName) from columns where UPPER(FULLNAME) = "PARTSSUPPLIER.PARTSSUPPLIER.PARTS.PART_COLOR"
PARTSSUPPLIER.PARTSSUPPLIER.PARTS.PART_COLOR

select UCASE(FullName) from columns where UCASE(FULLNAME) = "PARTSSUPPLIER.PARTSSUPPLIER.PARTS.PART_COLOR"
PARTSSUPPLIER.PARTSSUPPLIER.PARTS.PART_COLOR

select LOWER(FullName) from columns where LOWER(FULLNAME) = "partssupplier.partssupplier.parts.part_color"
partssupplier.partssupplier.parts.part_color

select LCASE(FullName) from columns where LCASE(FULLNAME) = "partssupplier.partssupplier.parts.part_color"
partssupplier.partssupplier.parts.part_color

select LCASE(FullName) from columns where LCASE(FULLNAME) LIKE "partssupplier.partssupplier.parts.part_color"
partssupplier.partssupplier.parts.part_color

select LCASE(FullName) from columns where UCASE(FULLNAME) = "partssupplier.partssupplier.parts.part_color"

select LCASE(FullName) from columns where UCASE(FULLNAME) = UCASE("partssupplier.partssupplier.parts.part_color")
partssupplier.partssupplier.parts.part_color

select LCASE(FullName) from columns where UCASE(FULLNAME) = LCASE("partssupplier.partssupplier.parts.part_color")

select LCASE(FullName) from columns where UCASE(FULLNAME) = UPPER("partssupplier.partssupplier.parts.part_color")
partssupplier.partssupplier.parts.part_color

select LCASE(FullName) from columns where UCASE(FULLNAME) = LOWER("partssupplier.partssupplier.parts.part_color")

select FullName, supportsUpdate from tables where fullname is null

select LCASE(FullName) from columns where LCASE(FULLNAME) LIKE "%.parts.part_color"
partssupplier.partssupplier.parts.part_color

select LCASE(FullName) from columns where LCASE(FULLNAME) IN ("partssupplier.partssupplier.parts.part_color", "partssupplier.partssupplier.parts.part_name")
partssupplier.partssupplier.parts.part_color
partssupplier.partssupplier.parts.part_name