local schemata= grtV.getGlobal("/wb/doc/physicalModels/0/catalog/schemata/1/tables") local i local j print("\n" ) print("\n" ) print("\n" ) print("\n" ) print(" \n" ) for i=1, grtV.getn(schemata) do print(" \n" ) print(" \n" ) print(" \n " ) print(" \n" ) print(" \n" ) print(" \n") print(" \n" ) print(" \n" ) print(" \n") print(" \n") print(" \n") print(" \n") print(" \n") print(" \n" ) for j=1, grtV.getn(schemata[i].columns) do print(" \n" ) print ( " \n" ) print ( " \n" ) if (schemata[i].columns[j].isNotNull == 1) then print (" \n" ) else print ( " \n" ) end if (schemata[i].columns[j].autoIncrement == 1) then print (" \n" ) else print (" \n" ) end print ( " \n" ) print(" \n" ) end print("
TABLE NAME: " .. schemata[i].name .. " \n") print("
TABLE DESCRIPTION: " .. schemata[i].comment .. " \n") print("
COLUMN_NAMETYPENULLABLE?AUTO_INCREMENT?COMMENTS
" .. schemata[i].columns[j].name .. "" .. schemata[i].columns[j].formattedType .. "" .. "NOT NULL" .. "" .. "NULL" .. "" .. "AUTO_INCREMENT" .. "" .. " - " .. "" .. schemata[i].columns[j].comment .. "
\n" ) print("
\n" ) end print ( "\n" ) print ( "\n" ) print ( "\n" )