Wednesday, 6 November 2019

Get List tables in MS Access database

///////// Query



select MSysObjects.name
from MSysObjects
where
   MSysObjects.type In (1,4,6)
   and MSysObjects.name not like '~*'  
   and MSysObjects.name not like 'MSys*'
order by MSysObjects.name



//////////Result/////////

                               

No comments:

Post a Comment

How to highlight selected text in notepad++

  –> To highlight a block of code in Notepad++, please do the following steps step-1  :- Select the required text. step-2  :- Right click...