Datadictionary OpenWave 3.1.25

View: vwadm_recordcount

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwadm_recordcount

Fields

Rules

Indices

There are no indices for table vwadm_recordcount

Definition

CREATE VIEW public.vwadm_recordcount (
   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 'tbaardbeslbezwaar'::text AS tabel,
   count(*) AS records
FROM tbaardbeslbezwaar
UNION
SELECT 'tbaardbeslsoortzaak'::text AS tabel,
   count(*) AS records
FROM tbaardbeslsoortzaak
UNION
SELECT 'tbaardbesluit'::text AS tabel,
   count(*) AS records
FROM tbaardbesluit
UNION
SELECT 'tbadm_objects'::text AS tabel,
   count(*) AS records
FROM tbadm_objects
UNION
SELECT 'tbadressoort'::text AS tabel,
   count(*) AS records
FROM tbadressoort
UNION
SELECT 'tbadvcatadvinstnn'::text AS tabel,
   count(*) AS records
FROM tbadvcatadvinstnn
UNION
SELECT 'tbadviescategorie'::text AS tabel,
   count(*) AS records
FROM tbadviescategorie
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 'tbapvspecificaties'::text AS tabel,
   count(*) AS records
FROM tbapvspecificaties
UNION
SELECT 'tbasbesttoegepast'::text AS tabel,
   count(*) AS records
FROM tbasbesttoegepast
UNION
SELECT 'tbaudit'::text AS tabel,
   count(*) AS records
FROM tbaudit
UNION
SELECT 'tbavpdigitaal'::text AS tabel,
   count(*) AS records
FROM tbavpdigitaal
UNION
SELECT 'tbavpkopwagens'::text AS tabel,
   count(*) AS records
FROM tbavpkopwagens
UNION
SELECT 'tbbadextupload'::text AS tabel,
   count(*) AS records
FROM tbbadextupload
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 'tbbestmaatreg'::text AS tabel,
   count(*) AS records
FROM tbbestmaatreg
UNION
SELECT 'tbbestplancategorie'::text AS tabel,
   count(*) AS records
FROM tbbestplancategorie
UNION
SELECT 'tbbestrechten'::text AS tabel,
   count(*) AS records
FROM tbbestrechten
UNION
SELECT 'tbbezwaarberoep'::text AS tabel,
   count(*) AS records
FROM tbbezwaarberoep
UNION
SELECT 'tbbezwaarcategorie'::text AS tabel,
   count(*) AS records
FROM tbbezwaarcategorie
UNION
SELECT 'tbbezwaarcontacten'::text AS tabel,
   count(*) AS records
FROM tbbezwaarcontacten
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 '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 'tbcbsbtwcategorie'::text AS tabel,
   count(*) AS records
FROM tbcbsbtwcategorie
UNION
SELECT 'tbcbsfincategorie'::text AS tabel,
   count(*) AS records
FROM tbcbsfincategorie
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 'tbcodeopschort'::text AS tabel,
   count(*) AS records
FROM tbcodeopschort
UNION
SELECT 'tbcompartiment'::text AS tabel,
   count(*) AS records
FROM tbcompartiment
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 'tbcorrespbijlages'::text AS tabel,
   count(*) AS records
FROM tbcorrespbijlages
UNION
SELECT 'tbcorrespbinnen'::text AS tabel,
   count(*) AS records
FROM tbcorrespbinnen
UNION
SELECT 'tbcorrespcollegtoets'::text AS tabel,
   count(*) AS records
FROM tbcorrespcollegtoets
UNION
SELECT 'tbcorrespondentie'::text AS tabel,
   count(*) AS records
FROM tbcorrespondentie
UNION
SELECT 'tbdefafschriften'::text AS tabel,
   count(*) AS records
FROM tbdefafschriften
UNION
SELECT 'tbdocparameters'::text AS tabel,
   count(*) AS records
FROM tbdocparameters
UNION
SELECT 'tbdocumenten'::text AS tabel,
   count(*) AS records
FROM tbdocumenten
UNION
SELECT 'tbdocumentsoorten'::text AS tabel,
   count(*) AS records
FROM tbdocumentsoorten
UNION
SELECT 'tbdocumenttype'::text AS tabel,
   count(*) AS records
FROM tbdocumenttype
UNION
SELECT 'tbdossierverblijf'::text AS tabel,
   count(*) AS records
FROM tbdossierverblijf
UNION
SELECT 'tbdroppublicaties'::text AS tabel,
   count(*) AS records
FROM tbdroppublicaties
UNION
SELECT 'tbdsogevrbijlages'::text AS tabel,
   count(*) AS records
FROM tbdsogevrbijlages
UNION
SELECT 'tbdsoproject'::text AS tabel,
   count(*) AS records
FROM tbdsoproject
UNION
SELECT 'tbdsospecificaties'::text AS tabel,
   count(*) AS records
FROM tbdsospecificaties
UNION
SELECT 'tbdsotrigger'::text AS tabel,
   count(*) AS records
FROM tbdsotrigger
UNION
SELECT 'tbekbedrijfstak'::text AS tabel,
   count(*) AS records
FROM tbekbedrijfstak
UNION
SELECT 'tbekrubricering'::text AS tabel,
   count(*) AS records
FROM tbekrubricering
UNION
SELECT 'tbeksoortmaatregel'::text AS tabel,
   count(*) AS records
FROM tbeksoortmaatregel
UNION
SELECT 'tbekteverwerkeninr'::text AS tabel,
   count(*) AS records
FROM tbekteverwerkeninr
UNION
SELECT 'tbemailparameters'::text AS tabel,
   count(*) AS records
FROM tbemailparameters
UNION
SELECT 'tbemailsjabloon'::text AS tabel,
   count(*) AS records
FROM tbemailsjabloon
UNION
SELECT 'tbemailsoorten'::text AS tabel,
   count(*) AS records
FROM tbemailsoorten
UNION
SELECT 'tbexportcontainer'::text AS tabel,
   count(*) AS records
FROM tbexportcontainer
UNION
SELECT 'tbexportscript'::text AS tabel,
   count(*) AS records
FROM tbexportscript
UNION
SELECT 'tbextramemo'::text AS tabel,
   count(*) AS records
FROM tbextramemo
UNION
SELECT 'tbgebouwen'::text AS tabel,
   count(*) AS records
FROM tbgebouwen
UNION
SELECT 'tbgebouwgebruik'::text AS tabel,
   count(*) AS records
FROM tbgebouwgebruik
UNION
SELECT 'tbgebouwspec'::text AS tabel,
   count(*) AS records
FROM tbgebouwspec
UNION
SELECT 'tbgebouwtype'::text AS tabel,
   count(*) AS records
FROM tbgebouwtype
UNION
SELECT 'tbgebruikersinformatie'::text AS tabel,
   count(*) AS records
FROM tbgebruikersinformatie
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 'tbhandhdwangsom'::text AS tabel,
   count(*) AS records
FROM tbhandhdwangsom
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 'tbhoraardbsrtzaak'::text AS tabel,
   count(*) AS records
FROM tbhoraardbsrtzaak
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 'tbimages'::text AS tabel,
   count(*) AS records
FROM tbimages
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 'tbinrcomplexiteit'::text AS tabel,
   count(*) AS records
FROM tbinrcomplexiteit
UNION
SELECT 'tbinspaanleiding'::text AS tabel,
   count(*) AS records
FROM tbinspaanleiding
UNION
SELECT 'tbinspaanlonderwerp'::text AS tabel,
   count(*) AS records
FROM tbinspaanlonderwerp
UNION
SELECT 'tbinspaanlsrtbez'::text AS tabel,
   count(*) AS records
FROM tbinspaanlsrtbez
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 'tbipranges'::text AS tabel,
   count(*) AS records
FROM tbipranges
UNION
SELECT 'tbkadastralegem'::text AS tabel,
   count(*) AS records
FROM tbkadastralegem
UNION
SELECT 'tbklachtafrond'::text AS tabel,
   count(*) AS records
FROM tbklachtafrond
UNION
SELECT 'tbklachtbinkomstcat'::text AS tabel,
   count(*) AS records
FROM tbklachtbinkomstcat
UNION
SELECT 'tbklachtbinkomsttype'::text AS tabel,
   count(*) AS records
FROM tbklachtbinkomsttype
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 'tbkopcompgem'::text AS tabel,
   count(*) AS records
FROM tbkopcompgem
UNION
SELECT 'tbkopcompsrtbwvverg'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrtbwvverg
UNION
SELECT 'tbkopcompsrthhzaak'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrthhzaak
UNION
SELECT 'tbkopcompsrthorverg'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrthorverg
UNION
SELECT 'tbkopcompsrtinfoav'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrtinfoav
UNION
SELECT 'tbkopcompsrtmilinr'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrtmilinr
UNION
SELECT 'tbkopcompsrtmilverg'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrtmilverg
UNION
SELECT 'tbkopcompsrtomgverg'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrtomgverg
UNION
SELECT 'tbkopcompsrtovvverg'::text AS tabel,
   count(*) AS records
FROM tbkopcompsrtovvverg
UNION
SELECT 'tbkopproccheck'::text AS tabel,
   count(*) AS records
FROM tbkopproccheck
UNION
SELECT 'tbkoppublgemzaak'::text AS tabel,
   count(*) AS records
FROM tbkoppublgemzaak
UNION
SELECT 'tbkoptoestadv'::text AS tabel,
   count(*) AS records
FROM tbkoptoestadv
UNION
SELECT 'tbkopurggem'::text AS tabel,
   count(*) AS records
FROM tbkopurggem
UNION
SELECT 'tblegesberekeningen'::text AS tabel,
   count(*) AS records
FROM tblegesberekeningen
UNION
SELECT 'tblegesexport'::text AS tabel,
   count(*) AS records
FROM tblegesexport
UNION
SELECT 'tblegesregels'::text AS tabel,
   count(*) AS records
FROM tblegesregels
UNION
SELECT 'tblegessoort'::text AS tabel,
   count(*) AS records
FROM tblegessoort
UNION
SELECT 'tblhsmatrix'::text AS tabel,
   count(*) AS records
FROM tblhsmatrix
UNION
SELECT 'tbloginverklaringen'::text AS tabel,
   count(*) AS records
FROM tbloginverklaringen
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 'tbmedewisadviseurvoor'::text AS tabel,
   count(*) AS records
FROM tbmedewisadviseurvoor
UNION
SELECT 'tbmedewtiles'::text AS tabel,
   count(*) AS records
FROM tbmedewtiles
UNION
SELECT 'tbmessagelog'::text AS tabel,
   count(*) AS records
FROM tbmessagelog
UNION
SELECT 'tbmewafdeling'::text AS tabel,
   count(*) AS records
FROM tbmewafdeling
UNION
SELECT 'tbmiladropslag'::text AS tabel,
   count(*) AS records
FROM tbmiladropslag
UNION
SELECT 'tbmilafvalstoffen'::text AS tabel,
   count(*) AS records
FROM tbmilafvalstoffen
UNION
SELECT 'tbmilafvalvervoerders'::text AS tabel,
   count(*) AS records
FROM tbmilafvalvervoerders
UNION
SELECT 'tbmilalert'::text AS tabel,
   count(*) AS records
FROM tbmilalert
UNION
SELECT 'tbmilasbest'::text AS tabel,
   count(*) AS records
FROM tbmilasbest
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 'tbmilcodebwl'::text AS tabel,
   count(*) AS records
FROM tbmilcodebwl
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 'tbmilcodemba'::text AS tabel,
   count(*) AS records
FROM tbmilcodemba
UNION
SELECT 'tbmilcodepas'::text AS tabel,
   count(*) AS records
FROM tbmilcodepas
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 'tbmilduurzaamheidprojecten'::text AS tabel,
   count(*) AS records
FROM tbmilduurzaamheidprojecten
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 'tbmilenergieprojecten'::text AS tabel,
   count(*) AS records
FROM tbmilenergieprojecten
UNION
SELECT 'tbmilgebied'::text AS tabel,
   count(*) AS records
FROM tbmilgebied
UNION
SELECT 'tbmilinrichtingen'::text AS tabel,
   count(*) AS records
FROM tbmilinrichtingen
UNION
SELECT 'tbmilinrvervoer'::text AS tabel,
   count(*) AS records
FROM tbmilinrvervoer
UNION
SELECT 'tbmilippccat'::text AS tabel,
   count(*) AS records
FROM tbmilippccat
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 'tbmilmba'::text AS tabel,
   count(*) AS records
FROM tbmilmba
UNION
SELECT 'tbmilnagetech'::text AS tabel,
   count(*) AS records
FROM tbmilnagetech
UNION
SELECT 'tbmilnaleving'::text AS tabel,
   count(*) AS records
FROM tbmilnaleving
UNION
SELECT 'tbmilomsradius'::text AS tabel,
   count(*) AS records
FROM tbmilomsradius
UNION
SELECT 'tbmilopslag'::text AS tabel,
   count(*) AS records
FROM tbmilopslag
UNION
SELECT 'tbmilprojecten'::text AS tabel,
   count(*) AS records
FROM tbmilprojecten
UNION
SELECT 'tbmilravbwl'::text AS tabel,
   count(*) AS records
FROM tbmilravbwl
UNION
SELECT 'tbmilrechten'::text AS tabel,
   count(*) AS records
FROM tbmilrechten
UNION
SELECT 'tbmilrubriek'::text AS tabel,
   count(*) AS records
FROM tbmilrubriek
UNION
SELECT 'tbmilsbi'::text AS tabel,
   count(*) AS records
FROM tbmilsbi
UNION
SELECT 'tbmilsrtafvalstof'::text AS tabel,
   count(*) AS records
FROM tbmilsrtafvalstof
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 'tbmilstal'::text AS tabel,
   count(*) AS records
FROM tbmilstal
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 'tbmilverbruikcat'::text AS tabel,
   count(*) AS records
FROM tbmilverbruikcat
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 'tbmilvervoerders'::text AS tabel,
   count(*) AS records
FROM tbmilvervoerders
UNION
SELECT 'tbmilvervoerprojecten'::text AS tabel,
   count(*) AS records
FROM tbmilvervoerprojecten
UNION
SELECT 'tbmilvoorzopslag'::text AS tabel,
   count(*) AS records
FROM tbmilvoorzopslag
UNION
SELECT 'tbmilwerkz'::text AS tabel,
   count(*) AS records
FROM tbmilwerkz
UNION
SELECT 'tbmilzzsklasse'::text AS tabel,
   count(*) AS records
FROM tbmilzzsklasse
UNION
SELECT 'tbmissingconfiguration'::text AS tabel,
   count(*) AS records
FROM tbmissingconfiguration
UNION
SELECT 'tbmonumenten'::text AS tabel,
   count(*) AS records
FROM tbmonumenten
UNION
SELECT 'tbmwloginverklaringen'::text AS tabel,
   count(*) AS records
FROM tbmwloginverklaringen
UNION
SELECT 'tbmwteams'::text AS tabel,
   count(*) AS records
FROM tbmwteams
UNION
SELECT 'tbnationaliteiten'::text AS tabel,
   count(*) AS records
FROM tbnationaliteiten
UNION
SELECT 'tboin'::text AS tabel,
   count(*) AS records
FROM tboin
UNION
SELECT 'tbomgbevgezhistorie'::text AS tabel,
   count(*) AS records
FROM tbomgbevgezhistorie
UNION
SELECT 'tbomgbewaarresulttoest'::text AS tabel,
   count(*) AS records
FROM tbomgbewaarresulttoest
UNION
SELECT 'tbomgbwinstallaties'::text AS tabel,
   count(*) AS records
FROM tbomgbwinstallaties
UNION
SELECT 'tbomgerkmaatreg'::text AS tabel,
   count(*) AS records
FROM tbomgerkmaatreg
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 'tbomguitvinsthistorie'::text AS tabel,
   count(*) AS records
FROM tbomguitvinsthistorie
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 'tboperationslog'::text AS tabel,
   count(*) AS records
FROM tboperationslog
UNION
SELECT 'tbopschorten'::text AS tabel,
   count(*) AS records
FROM tbopschorten
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 tbportaltiles
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 'tbprocitemcheck'::text AS tabel,
   count(*) AS records
FROM tbprocitemcheck
UNION
SELECT 'tbprocitems'::text AS tabel,
   count(*) AS records
FROM tbprocitems
UNION
SELECT 'tbproductdef'::text AS tabel,
   count(*) AS records
FROM tbproductdef
UNION
SELECT 'tbproducten'::text AS tabel,
   count(*) AS records
FROM tbproducten
UNION
SELECT 'tbproductklanten'::text AS tabel,
   count(*) AS records
FROM tbproductklanten
UNION
SELECT 'tbproductwerkpakketten'::text AS tabel,
   count(*) AS records
FROM tbproductwerkpakketten
UNION
SELECT 'tbprodwkpklant'::text AS tabel,
   count(*) AS records
FROM tbprodwkpklant
UNION
SELECT 'tbprogncategorie'::text AS tabel,
   count(*) AS records
FROM tbprogncategorie
UNION
SELECT 'tbprognose'::text AS tabel,
   count(*) AS records
FROM tbprognose
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 'tbrechtengroepmappen'::text AS tabel,
   count(*) AS records
FROM tbrechtengroepmappen
UNION
SELECT 'tbredenaanhouding'::text AS tabel,
   count(*) AS records
FROM tbredenaanhouding
UNION
SELECT 'tbrestflexfuncties'::text AS tabel,
   count(*) AS records
FROM tbrestflexfuncties
UNION
SELECT 'tbretouradvies'::text AS tabel,
   count(*) AS records
FROM tbretouradvies
UNION
SELECT 'tbroebbtw'::text AS tabel,
   count(*) AS records
FROM tbroebbtw
UNION
SELECT 'tbroebhfdcat'::text AS tabel,
   count(*) AS records
FROM tbroebhfdcat
UNION
SELECT 'tbroebprijzen'::text AS tabel,
   count(*) AS records
FROM tbroebprijzen
UNION
SELECT 'tbroebstaffel'::text AS tabel,
   count(*) AS records
FROM tbroebstaffel
UNION
SELECT 'tbroebsubcat'::text AS tabel,
   count(*) AS records
FROM tbroebsubcat
UNION
SELECT 'tbroebtoest'::text AS tabel,
   count(*) AS records
FROM tbroebtoest
UNION
SELECT 'tbscreencolumns'::text AS tabel,
   count(*) AS records
FROM tbscreencolumns
UNION
SELECT 'tbsession'::text AS tabel,
   count(*) AS records
FROM tbsession
UNION
SELECT 'tbsoortbezwaar'::text AS tabel,
   count(*) AS records
FROM tbsoortbezwaar
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 'tbsoorturen'::text AS tabel,
   count(*) AS records
FROM tbsoorturen
UNION
SELECT 'tbsrtbestmaatr'::text AS tabel,
   count(*) AS records
FROM tbsrtbestmaatr
UNION
SELECT 'tbsrtbestplan'::text AS tabel,
   count(*) AS records
FROM tbsrtbestplan
UNION
SELECT 'tbsrttoestemming'::text AS tabel,
   count(*) AS records
FROM tbsrttoestemming
UNION
SELECT 'tbsubproductdef'::text AS tabel,
   count(*) AS records
FROM tbsubproductdef
UNION
SELECT 'tbsubproducten'::text AS tabel,
   count(*) AS records
FROM tbsubproducten
UNION
SELECT 'tbswfactieverzoeken'::text AS tabel,
   count(*) AS records
FROM tbswfactieverzoeken
UNION
SELECT 'tbswfdocumenten'::text AS tabel,
   count(*) AS records
FROM tbswfdocumenten
UNION
SELECT 'tbswfnotificaties'::text AS tabel,
   count(*) AS records
FROM tbswfnotificaties
UNION
SELECT 'tbswfoinpartners'::text AS tabel,
   count(*) AS records
FROM tbswfoinpartners
UNION
SELECT 'tbswfruimte'::text AS tabel,
   count(*) AS records
FROM tbswfruimte
UNION
SELECT 'tbsysstandardbutton'::text AS tabel,
   count(*) AS records
FROM tbsysstandardbutton
UNION
SELECT 'tbsysstandardcategorie'::text AS tabel,
   count(*) AS records
FROM tbsysstandardcategorie
UNION
SELECT 'tbsysstandardtable'::text AS tabel,
   count(*) AS records
FROM tbsysstandardtable
UNION
SELECT 'tbtaskscheduler'::text AS tabel,
   count(*) AS records
FROM tbtaskscheduler
UNION
SELECT 'tbteams'::text AS tabel,
   count(*) AS records
FROM tbteams
UNION
SELECT 'tbtekstblokken'::text AS tabel,
   count(*) AS records
FROM tbtekstblokken
UNION
SELECT 'tbtermijnbewstappen'::text AS tabel,
   count(*) AS records
FROM tbtermijnbewstappen
UNION
SELECT 'tbtevernietigen'::text AS tabel,
   count(*) AS records
FROM tbtevernietigen
UNION
SELECT 'tbtoestemmingen'::text AS tabel,
   count(*) AS records
FROM tbtoestemmingen
UNION
SELECT 'tbupload'::text AS tabel,
   count(*) AS records
FROM tbupload
UNION
SELECT 'tburen'::text AS tabel,
   count(*) AS records
FROM tburen
UNION
SELECT 'tbvertrouwelijkheid'::text AS tabel,
   count(*) AS records
FROM tbvertrouwelijkheid
UNION
SELECT 'tbverzendlijst'::text AS tabel,
   count(*) AS records
FROM tbverzendlijst
UNION
SELECT 'tbvolgzaak'::text AS tabel,
   count(*) AS records
FROM tbvolgzaak
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 'tbwmdoelgroep'::text AS tabel,
   count(*) AS records
FROM tbwmdoelgroep
UNION
SELECT 'tbwmeigendomprijs'::text AS tabel,
   count(*) AS records
FROM tbwmeigendomprijs
UNION
SELECT 'tbwmtypewoningen'::text AS tabel,
   count(*) AS records
FROM tbwmtypewoningen
UNION
SELECT 'tbwmtyptebouwproductie'::text AS tabel,
   count(*) AS records
FROM tbwmtyptebouwproductie
UNION
SELECT 'tbwoonplaats'::text AS tabel,
   count(*) AS records
FROM tbwoonplaats
UNION
SELECT 'tbzaakdomein'::text AS tabel,
   count(*) AS records
FROM tbzaakdomein
UNION
SELECT 'tbzaakkadperc'::text AS tabel,
   count(*) AS records
FROM tbzaakkadperc
UNION
SELECT 'tbzaakproducten'::text AS tabel,
   count(*) AS records
FROM tbzaakproducten
UNION
SELECT 'tbzaakstatus'::text AS tabel,
   count(*) AS records
FROM tbzaakstatus
UNION
SELECT 'tbzaaktypedoctype'::text AS tabel,
   count(*) AS records
FROM tbzaaktypedoctype
UNION
SELECT 'tbzaaktypedocumentsoorten'::text AS tabel,
   count(*) AS records
FROM tbzaaktypedocumentsoorten;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13