Questões de Concurso

select name, type_desc, modify_date

from model.information

where type = 'SYSTEM'

     and modify_date

         between '01/01/2024' and '31/01/24'

select name, type_desc, modify_date

from sys.information

where modify_date

     between '01/01/2024' and '31/01/2024'

select name, type_desc, modify_date

from view.tables

where type = 'USER'

     and modify_date

         between '01/01/2024' and '31/01/24'

select name, type_desc, modify_date

from sys.tables

where type = 'U'

     and modify_date

         between '01/01/2024' and '31/01/24'

select name, type_desc, modify_date

from DICTIONARY

where type = 'SYSTEM'

     and modify_date

         between '01/01/2024' and '31/01/24'