Datadictionary OpenWave 3.1.11 |
|
View: vwadm_recordcount
Datadictionary OpenWave 3.1.11 |
|
View: vwadm_recordcount
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadm_recordcount
Fields
Name | Data type | Description |
|---|---|---|
tabel |
text |
|
records |
bigint |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
tabel,
records)
AS
( ( ( ( ( ( ( (
( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( (
SELECT 'tb33gemeente'::text AS tabel,
count(*) AS records
FROM tb33gemeente
UNION
SELECT 'tbaanvalsplannen'::text AS tabel,
count(*) AS records
FROM tbaanvalsplannen)
UNION
SELECT 'tbaardbesluit'::text AS tabel,
count(*) AS records
FROM tbaardbesluit)
UNION
SELECT 'tbaardbeslsoortzaak'::text AS tabel,
count(*) AS records
FROM tbaardbeslsoortzaak)
UNION
SELECT 'tbadressoort'::text AS tabel,
count(*) AS records
FROM tbadressoort)
UNION
SELECT 'tbadviesinstanties'::text AS tabel,
count(*) AS records
FROM tbadviesinstanties)
UNION
SELECT 'tbadvieswelstand'::text AS tabel,
count(*) AS records
FROM tbadvieswelstand)
UNION
SELECT 'tbadviezen'::text AS tabel,
count(*) AS records
FROM tbadviezen)
UNION
SELECT 'tbavpdigitaal'::text AS tabel,
count(*) AS records
FROM tbavpdigitaal)
UNION
SELECT 'tbavpkopwagens'::text AS tabel,
count(*) AS records
FROM tbavpkopwagens)
UNION
SELECT 'tbbesluittypes'::text AS tabel,
count(*) AS records
FROM tbbesluittypes)
UNION
SELECT 'tbbestemcontactennn'::text AS tabel,
count(*) AS records
FROM tbbestemcontactennn)
UNION
SELECT 'tbbestemmingsplannen'::text AS tabel,
count(*) AS records
FROM tbbestemmingsplannen)
UNION
SELECT 'tbbestemtoetscriteria'::text AS tabel,
count(*) AS records
FROM tbbestemtoetscriteria)
UNION
SELECT 'tbbestplancategorie'::text AS tabel,
count(*) AS records
FROM tbbestplancategorie)
UNION
SELECT 'tbbestrechten'::text AS tabel,
count(*) AS records
FROM tbbestrechten)
UNION
SELECT 'tbbouwafwgeldbpl'::text AS tabel,
count(*) AS records
FROM tbbouwafwgeldbpl)
UNION
SELECT 'tbbouwafwnwbpl'::text AS tabel,
count(*) AS records
FROM tbbouwafwnwbpl)
UNION
SELECT 'tbbouwcontactennn'::text AS tabel,
count(*) AS records
FROM tbbouwcontactennn)
UNION
SELECT 'tbbouwvergunningen'::text AS tabel,
count(*) AS records
FROM tbbouwvergunningen)
UNION
SELECT 'tbbouwvrijgeldbplnn'::text AS tabel,
count(*) AS records
FROM tbbouwvrijgeldbplnn)
UNION
SELECT 'tbbouwvrijnwbplnn'::text AS tabel,
count(*) AS records
FROM tbbouwvrijnwbplnn)
UNION
SELECT 'tbbouwwerkz'::text AS tabel,
count(*) AS records
FROM tbbouwwerkz)
UNION
SELECT 'tbbwaantekeningen'::text AS tabel,
count(*) AS records
FROM tbbwaantekeningen)
UNION
SELECT 'tbbwinstallaties'::text AS tabel,
count(*) AS records
FROM tbbwinstallaties)
UNION
SELECT 'tbcbsbtwcategorie'::text AS tabel,
count(*) AS records
FROM tbcbsbtwcategorie)
UNION
SELECT 'tbcbsfincategorie'::text AS tabel,
count(*) AS records
FROM tbcbsfincategorie)
UNION
SELECT 'tbcbs_gegevens_w011'::text AS tabel,
count(*) AS records
FROM tbcbs_gegevens_w011)
UNION
SELECT 'tbcbs_gegevens_w015'::text AS tabel,
count(*) AS records
FROM tbcbs_gegevens_w015)
UNION
SELECT 'tbchecklistnaam'::text AS tabel,
count(*) AS records
FROM tbchecklistnaam)
UNION
SELECT 'tbchkitbeheer'::text AS tabel,
count(*) AS records
FROM tbchkitbeheer)
UNION
SELECT 'tbchkitwerk'::text AS tabel,
count(*) AS records
FROM tbchkitwerk)
UNION
SELECT 'tbcontactadressen'::text AS tabel,
count(*) AS records
FROM tbcontactadressen)
UNION
SELECT 'tbcontrgebouwtype'::text AS tabel,
count(*) AS records
FROM tbcontrgebouwtype)
UNION
SELECT 'tbcorafschriften'::text AS tabel,
count(*) AS records
FROM tbcorafschriften)
UNION
SELECT 'tbcorrespbinnen'::text AS tabel,
count(*) AS records
FROM tbcorrespbinnen)
UNION
SELECT 'tbcorrespondentie'::text AS tabel,
count(*) AS records
FROM tbcorrespondentie)
UNION
SELECT 'tbdefafschriften'::text AS tabel,
count(*) AS records
FROM tbdefafschriften)
UNION
SELECT 'tbdocumenten'::text AS tabel,
count(*) AS records
FROM tbdocumenten)
UNION
SELECT 'tbdocumentsoorten'::text AS tabel,
count(*) AS records
FROM tbdocumentsoorten)
UNION
SELECT 'tbdossierverblijf'::text AS tabel,
count(*) AS records
FROM tbdossierverblijf)
UNION
SELECT 'tbextramemo'::text AS tabel,
count(*) AS records
FROM tbextramemo)
UNION
SELECT 'tbgebouwen'::text AS tabel,
count(*) AS records
FROM tbgebouwen)
UNION
SELECT 'tbgebouwspec'::text AS tabel,
count(*) AS records
FROM tbgebouwspec)
UNION
SELECT 'tbgebouwtype'::text AS tabel,
count(*) AS records
FROM tbgebouwtype)
UNION
SELECT 'tbgeowms'::text AS tabel,
count(*) AS records
FROM tbgeowms)
UNION
SELECT 'tbgroepvergunning'::text AS tabel,
count(*) AS records
FROM tbgroepvergunning)
UNION
SELECT 'tbhandhafronding'::text AS tabel,
count(*) AS records
FROM tbhandhafronding)
UNION
SELECT 'tbhandhavingen'::text AS tabel,
count(*) AS records
FROM tbhandhavingen)
UNION
SELECT 'tbhandhbestmaatr'::text AS tabel,
count(*) AS records
FROM tbhandhbestmaatr)
UNION
SELECT 'tbhandhcontactennn'::text AS tabel,
count(*) AS records
FROM tbhandhcontactennn)
UNION
SELECT 'tbhandhinvorderingen'::text AS tabel,
count(*) AS records
FROM tbhandhinvorderingen)
UNION
SELECT 'tbhandhovertreding'::text AS tabel,
count(*) AS records
FROM tbhandhovertreding)
UNION
SELECT 'tbhandhprojekten'::text AS tabel,
count(*) AS records
FROM tbhandhprojekten)
UNION
SELECT 'tbhandhwetbasis'::text AS tabel,
count(*) AS records
FROM tbhandhwetbasis)
UNION
SELECT 'tbhhafrondsoortzaak'::text AS tabel,
count(*) AS records
FROM tbhhafrondsoortzaak)
UNION
SELECT 'tbhhbestmaatregnn'::text AS tabel,
count(*) AS records
FROM tbhhbestmaatregnn)
UNION
SELECT 'tbhhrechten'::text AS tabel,
count(*) AS records
FROM tbhhrechten)
UNION
SELECT 'tbhoraardbesluit'::text AS tabel,
count(*) AS records
FROM tbhoraardbesluit)
UNION
SELECT 'tbhorbeperkingen'::text AS tabel,
count(*) AS records
FROM tbhorbeperkingen)
UNION
SELECT 'tbhorecacontactennn'::text AS tabel,
count(*) AS records
FROM tbhorecacontactennn)
UNION
SELECT 'tbhorecavergunningen'::text AS tabel,
count(*) AS records
FROM tbhorecavergunningen)
UNION
SELECT 'tbhorexploitatie'::text AS tabel,
count(*) AS records
FROM tbhorexploitatie)
UNION
SELECT 'tbhorgebied'::text AS tabel,
count(*) AS records
FROM tbhorgebied)
UNION
SELECT 'tbhorklachten'::text AS tabel,
count(*) AS records
FROM tbhorklachten)
UNION
SELECT 'tbhorlokaliteiten'::text AS tabel,
count(*) AS records
FROM tbhorlokaliteiten)
UNION
SELECT 'tbhorontheffingen'::text AS tabel,
count(*) AS records
FROM tbhorontheffingen)
UNION
SELECT 'tbhorrechten'::text AS tabel,
count(*) AS records
FROM tbhorrechten)
UNION
SELECT 'tbhorrechtsvorm'::text AS tabel,
count(*) AS records
FROM tbhorrechtsvorm)
UNION
SELECT 'tbhorredenaanvraag'::text AS tabel,
count(*) AS records
FROM tbhorredenaanvraag)
UNION
SELECT 'tbhorsluitingen'::text AS tabel,
count(*) AS records
FROM tbhorsluitingen)
UNION
SELECT 'tbhorsluitingstijden'::text AS tabel,
count(*) AS records
FROM tbhorsluitingstijden)
UNION
SELECT 'tbhorsoortexploitatie'::text AS tabel,
count(*) AS records
FROM tbhorsoortexploitatie)
UNION
SELECT 'tbhorsoortklacht'::text AS tabel,
count(*) AS records
FROM tbhorsoortklacht)
UNION
SELECT 'tbhorspautcategorie'::text AS tabel,
count(*) AS records
FROM tbhorspautcategorie)
UNION
SELECT 'tbhorspeelautomaten'::text AS tabel,
count(*) AS records
FROM tbhorspeelautomaten)
UNION
SELECT 'tbhorsrtonderneming'::text AS tabel,
count(*) AS records
FROM tbhorsrtonderneming)
UNION
SELECT 'tbhorterras'::text AS tabel,
count(*) AS records
FROM tbhorterras)
UNION
SELECT 'tbinbehandelingbij'::text AS tabel,
count(*) AS records
FROM tbinbehandelingbij)
UNION
SELECT 'tbinfoaanvragen'::text AS tabel,
count(*) AS records
FROM tbinfoaanvragen)
UNION
SELECT 'tbinfocontactennn'::text AS tabel,
count(*) AS records
FROM tbinfocontactennn)
UNION
SELECT 'tbinforechten'::text AS tabel,
count(*) AS records
FROM tbinforechten)
UNION
SELECT 'tbinfotrefwoord'::text AS tabel,
count(*) AS records
FROM tbinfotrefwoord)
UNION
SELECT 'tbinfotrefwoordennn'::text AS tabel,
count(*) AS records
FROM tbinfotrefwoordennn)
UNION
SELECT 'tbinitialisatie'::text AS tabel,
count(*) AS records
FROM tbinitialisatie)
UNION
SELECT 'tbinspaanleiding'::text AS tabel,
count(*) AS records
FROM tbinspaanleiding)
UNION
SELECT 'tbinspbesturingsmodel'::text AS tabel,
count(*) AS records
FROM tbinspbesturingsmodel)
UNION
SELECT 'tbinspbezoeken'::text AS tabel,
count(*) AS records
FROM tbinspbezoeken)
UNION
SELECT 'tbinspecties'::text AS tabel,
count(*) AS records
FROM tbinspecties)
UNION
SELECT 'tbinsponderwerpen'::text AS tabel,
count(*) AS records
FROM tbinsponderwerpen)
UNION
SELECT 'tbinsponrechtm'::text AS tabel,
count(*) AS records
FROM tbinsponrechtm)
UNION
SELECT 'tbinspovertrgebouw'::text AS tabel,
count(*) AS records
FROM tbinspovertrgebouw)
UNION
SELECT 'tbinspresultaat'::text AS tabel,
count(*) AS records
FROM tbinspresultaat)
UNION
SELECT 'tbinspsoortbezoek'::text AS tabel,
count(*) AS records
FROM tbinspsoortbezoek)
UNION
SELECT 'tbinsptermijnoplovertr'::text AS tabel,
count(*) AS records
FROM tbinsptermijnoplovertr)
UNION
SELECT 'tbinspwaaromovertreding'::text AS tabel,
count(*) AS records
FROM tbinspwaaromovertreding)
UNION
SELECT 'tbkadastralegem'::text AS tabel,
count(*) AS records
FROM tbkadastralegem)
UNION
SELECT 'tbklachtafrond'::text AS tabel,
count(*) AS records
FROM tbklachtafrond)
UNION
SELECT 'tbklachten'::text AS tabel,
count(*) AS records
FROM tbklachten)
UNION
SELECT 'tbklachternst'::text AS tabel,
count(*) AS records
FROM tbklachternst)
UNION
SELECT 'tbklachtfreq'::text AS tabel,
count(*) AS records
FROM tbklachtfreq)
UNION
SELECT 'tbklachtoverlast'::text AS tabel,
count(*) AS records
FROM tbklachtoverlast)
UNION
SELECT 'tbklachtvorm'::text AS tabel,
count(*) AS records
FROM tbklachtvorm)
UNION
SELECT 'tbkopproccheck'::text AS tabel,
count(*) AS records
FROM tbkopproccheck)
UNION
SELECT 'tbkoptoestadv'::text AS tabel,
count(*) AS records
FROM tbkoptoestadv)
UNION
SELECT 'tblegesberekeningen'::text AS tabel,
count(*) AS records
FROM tblegesberekeningen)
UNION
SELECT 'tblegesregels'::text AS tabel,
count(*) AS records
FROM tblegesregels)
UNION
SELECT 'tblegessoort'::text AS tabel,
count(*) AS records
FROM tblegessoort)
UNION
SELECT 'tblokcrititems'::text AS tabel,
count(*) AS records
FROM tblokcrititems)
UNION
SELECT 'tblokcritkoppel'::text AS tabel,
count(*) AS records
FROM tblokcritkoppel)
UNION
SELECT 'tblokcritlijsten'::text AS tabel,
count(*) AS records
FROM tblokcritlijsten)
UNION
SELECT 'tbmedewdevices'::text AS tabel,
count(*) AS records
FROM tbmedewdevices)
UNION
SELECT 'tbmedewerkers'::text AS tabel,
count(*) AS records
FROM tbmedewerkers)
UNION
SELECT 'tbmedewtiles'::text AS tabel,
count(*) AS records
FROM tbmedewtiles)
UNION
SELECT 'tbmiladropslag'::text AS tabel,
count(*) AS records
FROM tbmiladropslag)
UNION
SELECT 'tbmilbedrijfeinde'::text AS tabel,
count(*) AS records
FROM tbmilbedrijfeinde)
UNION
SELECT 'tbmilbedrijfsoort'::text AS tabel,
count(*) AS records
FROM tbmilbedrijfsoort)
UNION
SELECT 'tbmilcertificaten'::text AS tabel,
count(*) AS records
FROM tbmilcertificaten)
UNION
SELECT 'tbmilcodecertif'::text AS tabel,
count(*) AS records
FROM tbmilcodecertif)
UNION
SELECT 'tbmilcodedier'::text AS tabel,
count(*) AS records
FROM tbmilcodedier)
UNION
SELECT 'tbmilcodeenergie'::text AS tabel,
count(*) AS records
FROM tbmilcodeenergie)
UNION
SELECT 'tbmilcodeivb'::text AS tabel,
count(*) AS records
FROM tbmilcodeivb)
UNION
SELECT 'tbmilcodesbi'::text AS tabel,
count(*) AS records
FROM tbmilcodesbi)
UNION
SELECT 'tbmilcodestal'::text AS tabel,
count(*) AS records
FROM tbmilcodestal)
UNION
SELECT 'tbmilcodestaldier'::text AS tabel,
count(*) AS records
FROM tbmilcodestaldier)
UNION
SELECT 'tbmilcodestof'::text AS tabel,
count(*) AS records
FROM tbmilcodestof)
UNION
SELECT 'tbmilcodetrefw'::text AS tabel,
count(*) AS records
FROM tbmilcodetrefw)
UNION
SELECT 'tbmilcodewetgrond'::text AS tabel,
count(*) AS records
FROM tbmilcodewetgrond)
UNION
SELECT 'tbmilcontactennn'::text AS tabel,
count(*) AS records
FROM tbmilcontactennn)
UNION
SELECT 'tbmildiversen'::text AS tabel,
count(*) AS records
FROM tbmildiversen)
UNION
SELECT 'tbmilemlctstof'::text AS tabel,
count(*) AS records
FROM tbmilemlctstof)
UNION
SELECT 'tbmilemlctvoorz'::text AS tabel,
count(*) AS records
FROM tbmilemlctvoorz)
UNION
SELECT 'tbmilemlucht'::text AS tabel,
count(*) AS records
FROM tbmilemlucht)
UNION
SELECT 'tbmilemstal'::text AS tabel,
count(*) AS records
FROM tbmilemstal)
UNION
SELECT 'tbmilemwateig'::text AS tabel,
count(*) AS records
FROM tbmilemwateig)
UNION
SELECT 'tbmilemwater'::text AS tabel,
count(*) AS records
FROM tbmilemwater)
UNION
SELECT 'tbmilemwatvoorz'::text AS tabel,
count(*) AS records
FROM tbmilemwatvoorz)
UNION
SELECT 'tbmilenergie'::text AS tabel,
count(*) AS records
FROM tbmilenergie)
UNION
SELECT 'tbmilgebied'::text AS tabel,
count(*) AS records
FROM tbmilgebied)
UNION
SELECT 'tbmilinrichtingen'::text AS tabel,
count(*) AS records
FROM tbmilinrichtingen)
UNION
SELECT 'tbmilivb'::text AS tabel,
count(*) AS records
FROM tbmilivb)
UNION
SELECT 'tbmiljurindic'::text AS tabel,
count(*) AS records
FROM tbmiljurindic)
UNION
SELECT 'tbmilkopvergsrt'::text AS tabel,
count(*) AS records
FROM tbmilkopvergsrt)
UNION
SELECT 'tbmilnagetech'::text AS tabel,
count(*) AS records
FROM tbmilnagetech)
UNION
SELECT 'tbmilnaleving'::text AS tabel,
count(*) AS records
FROM tbmilnaleving)
UNION
SELECT 'tbmilopslag'::text AS tabel,
count(*) AS records
FROM tbmilopslag)
UNION
SELECT 'tbmilrechten'::text AS tabel,
count(*) AS records
FROM tbmilrechten)
UNION
SELECT 'tbmilsbi'::text AS tabel,
count(*) AS records
FROM tbmilsbi)
UNION
SELECT 'tbmilsrtdivers'::text AS tabel,
count(*) AS records
FROM tbmilsrtdivers)
UNION
SELECT 'tbmilsrtlozing'::text AS tabel,
count(*) AS records
FROM tbmilsrtlozing)
UNION
SELECT 'tbmilsrtopslag'::text AS tabel,
count(*) AS records
FROM tbmilsrtopslag)
UNION
SELECT 'tbmilsrtvoorz'::text AS tabel,
count(*) AS records
FROM tbmilsrtvoorz)
UNION
SELECT 'tbmilstatusopslag'::text AS tabel,
count(*) AS records
FROM tbmilstatusopslag)
UNION
SELECT 'tbmiltrefwoord'::text AS tabel,
count(*) AS records
FROM tbmiltrefwoord)
UNION
SELECT 'tbmiltypegebied'::text AS tabel,
count(*) AS records
FROM tbmiltypegebied)
UNION
SELECT 'tbmilurgentie'::text AS tabel,
count(*) AS records
FROM tbmilurgentie)
UNION
SELECT 'tbmilvergamvbpl'::text AS tabel,
count(*) AS records
FROM tbmilvergamvbpl)
UNION
SELECT 'tbmilvergcontactennn'::text AS tabel,
count(*) AS records
FROM tbmilvergcontactennn)
UNION
SELECT 'tbmilvergrechten'::text AS tabel,
count(*) AS records
FROM tbmilvergrechten)
UNION
SELECT 'tbmilvergunningen'::text AS tabel,
count(*) AS records
FROM tbmilvergunningen)
UNION
SELECT 'tbmilvergwetgrond'::text AS tabel,
count(*) AS records
FROM tbmilvergwetgrond)
UNION
SELECT 'tbmilvoorzopslag'::text AS tabel,
count(*) AS records
FROM tbmilvoorzopslag)
UNION
SELECT 'tbmilwerkz'::text AS tabel,
count(*) AS records
FROM tbmilwerkz)
UNION
SELECT 'tbmonumenten'::text AS tabel,
count(*) AS records
FROM tbmonumenten)
UNION
SELECT 'tbnationaliteiten'::text AS tabel,
count(*) AS records
FROM tbnationaliteiten)
UNION
SELECT 'tbomgbwinstallaties'::text AS tabel,
count(*) AS records
FROM tbomgbwinstallaties)
UNION
SELECT 'tbomgoloberichten'::text AS tabel,
count(*) AS records
FROM tbomgoloberichten)
UNION
SELECT 'tbomgpreparaties'::text AS tabel,
count(*) AS records
FROM tbomgpreparaties)
UNION
SELECT 'tbomgrechten'::text AS tabel,
count(*) AS records
FROM tbomgrechten)
UNION
SELECT 'tbomgvergbestemtoets'::text AS tabel,
count(*) AS records
FROM tbomgvergbestemtoets)
UNION
SELECT 'tbomgvergcontactennn'::text AS tabel,
count(*) AS records
FROM tbomgvergcontactennn)
UNION
SELECT 'tbomgvergunning'::text AS tabel,
count(*) AS records
FROM tbomgvergunning)
UNION
SELECT 'tbomsinstallaties'::text AS tabel,
count(*) AS records
FROM tbomsinstallaties)
UNION
SELECT 'tbomskwal'::text AS tabel,
count(*) AS records
FROM tbomskwal)
UNION
SELECT 'tbomsmeldingen'::text AS tabel,
count(*) AS records
FROM tbomsmeldingen)
UNION
SELECT 'tbomsoorzaak'::text AS tabel,
count(*) AS records
FROM tbomsoorzaak)
UNION
SELECT 'tbomssrtmelder'::text AS tabel,
count(*) AS records
FROM tbomssrtmelder)
UNION
SELECT 'tbomssrtmelding'::text AS tabel,
count(*) AS records
FROM tbomssrtmelding)
UNION
SELECT 'tbomswvu'::text AS tabel,
count(*) AS records
FROM tbomswvu)
UNION
SELECT 'tbopenbareruimte'::text AS tabel,
count(*) AS records
FROM tbopenbareruimte)
UNION
SELECT 'tbovafwgeldbpl'::text AS tabel,
count(*) AS records
FROM tbovafwgeldbpl)
UNION
SELECT 'tbovafwnwbpl'::text AS tabel,
count(*) AS records
FROM tbovafwnwbpl)
UNION
SELECT 'tbovcontactennn'::text AS tabel,
count(*) AS records
FROM tbovcontactennn)
UNION
SELECT 'tbovrechten'::text AS tabel,
count(*) AS records
FROM tbovrechten)
UNION
SELECT 'tbovvergunningen'::text AS tabel,
count(*) AS records
FROM tbovvergunningen)
UNION
SELECT 'tbovvrijgeldbplnn'::text AS tabel,
count(*) AS records
FROM tbovvrijgeldbplnn)
UNION
SELECT 'tbovvrijnwbplnn'::text AS tabel,
count(*) AS records
FROM tbovvrijnwbplnn)
UNION
SELECT 'tbovwerkz'::text AS tabel,
count(*) AS records
FROM tbovwerkz)
UNION
SELECT 'tbperceeladressen'::text AS tabel,
count(*) AS records
FROM tbperceeladressen)
UNION
SELECT 'tbpgs'::text AS tabel,
count(*) AS records
FROM tbpgs)
UNION
SELECT 'tbportalcolumns'::text AS tabel,
count(*) AS records
FROM tbportalcolumns)
UNION
SELECT 'tbportalnames'::text AS tabel,
count(*) AS records
FROM tbportalnames)
UNION
SELECT 'tbportaltiles'::text AS tabel,
count(*) AS records
FROM tbportalnames)
UNION
SELECT 'tbpreparaties'::text AS tabel,
count(*) AS records
FROM tbpreparaties)
UNION
SELECT 'tbprocedures'::text AS tabel,
count(*) AS records
FROM tbprocedures)
UNION
SELECT 'tbproceduressoortplan'::text AS tabel,
count(*) AS records
FROM tbproceduressoortplan)
UNION
SELECT 'tbprocitems'::text AS tabel,
count(*) AS records
FROM tbprocitems)
UNION
SELECT 'tbqueries'::text AS tabel,
count(*) AS records
FROM tbqueries)
UNION
SELECT 'tbrapporten'::text AS tabel,
count(*) AS records
FROM tbrapporten)
UNION
SELECT 'tbrapportgroep'::text AS tabel,
count(*) AS records
FROM tbrapportgroep)
UNION
SELECT 'tbrapportparameters'::text AS tabel,
count(*) AS records
FROM tbrapportparameters)
UNION
SELECT 'tbrechten'::text AS tabel,
count(*) AS records
FROM tbrechten)
UNION
SELECT 'tbredenaanhouding'::text AS tabel,
count(*) AS records
FROM tbredenaanhouding)
UNION
SELECT 'tbretouradvies'::text AS tabel,
count(*) AS records
FROM tbretouradvies)
UNION
SELECT 'tbsession'::text AS tabel,
count(*) AS records
FROM tbsession)
UNION
SELECT 'tbsoortcorrbinnen'::text AS tabel,
count(*) AS records
FROM tbsoortcorrbinnen)
UNION
SELECT 'tbsoorthhzaak'::text AS tabel,
count(*) AS records
FROM tbsoorthhzaak)
UNION
SELECT 'tbsoorthorverg'::text AS tabel,
count(*) AS records
FROM tbsoorthorverg)
UNION
SELECT 'tbsoortinfoaanvraag'::text AS tabel,
count(*) AS records
FROM tbsoortinfoaanvraag)
UNION
SELECT 'tbsoortinvordering'::text AS tabel,
count(*) AS records
FROM tbsoortinvordering)
UNION
SELECT 'tbsoortmilverg'::text AS tabel,
count(*) AS records
FROM tbsoortmilverg)
UNION
SELECT 'tbsoortomgverg'::text AS tabel,
count(*) AS records
FROM tbsoortomgverg)
UNION
SELECT 'tbsoortovverg'::text AS tabel,
count(*) AS records
FROM tbsoortovverg)
UNION
SELECT 'tbsoortplan'::text AS tabel,
count(*) AS records
FROM tbsoortplan)
UNION
SELECT 'tbsrtbestplan'::text AS tabel,
count(*) AS records
FROM tbsrtbestplan)
UNION
SELECT 'tbsrttoestemming'::text AS tabel,
count(*) AS records
FROM tbsrttoestemming)
UNION
SELECT 'tbtermijnbewstappen'::text AS tabel,
count(*) AS records
FROM tbtermijnbewstappen)
UNION
SELECT 'tbtoestemmingen'::text AS tabel,
count(*) AS records
FROM tbtoestemmingen)
UNION
SELECT 'tbupload'::text AS tabel,
count(*)
AS records
FROM tbupload)
UNION
SELECT 'tbverzendlijst'::text AS tabel,
count(*) AS records
FROM tbverzendlijst)
UNION
SELECT 'tbvrijevelden'::text AS tabel,
count(*) AS records
FROM tbvrijevelden)
UNION
SELECT 'tbvrijeveldenbetekenissen'::text AS tabel,
count(*) AS records
FROM tbvrijeveldenbetekenissen)
UNION
SELECT 'tbwagens'::text AS tabel,
count(*) AS records
FROM tbwagens)
UNION
SELECT 'tbwelstandbeeldkwal'::text AS tabel,
count(*) AS records
FROM tbwelstandbeeldkwal)
UNION
SELECT 'tbwelstandcommissie'::text AS tabel,
count(*) AS records
FROM tbwelstandcommissie)
UNION
SELECT 'tbwelstandcriteria'::text AS tabel,
count(*) AS records
FROM tbwelstandcriteria)
UNION
SELECT 'tbwoonplaats'::text AS tabel, count(*) AS records
FROM tbwoonplaats;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|