view release on metacpan or  search on metacpan

t/common-sqlserver.t  view on Meta::CPAN

  my $date_typename = 'date';
  my $datetime_typename = 'datetime';

  sub date_typename { lc $date_typename }
  sub datetime_typename { lc $datetime_typename }

  my $date_datatype = -9;
  my $datetime_datatype = 93;

  sub date_datatype { lc $date_datatype }
  sub datetime_datatype { lc $datetime_datatype }

  has exclude_table => sub {
      return qr/^(
        CHECK_CONSTRAINTS
        |COLUMN_DOMAIN_USAGE
        |COLUMN_PRIVILEGES
        |COLUMNS
        |CONSTRAINT_COLUMN_USAGE
        |CONSTRAINT_TABLE_USAGE
        |DOMAIN_CONSTRAINTS
        |DOMAINS
        |KEY_COLUMN_USAGE
        |PARAMETERS
        |REFERENTIAL_CONSTRAINTS
        |ROUTINE_COLUMNS
        |ROUTINES
        |SCHEMATA
        |TABLE_CONSTRAINTS
        |TABLE_PRIVILEGES
        |TABLES
        |VIEW_COLUMN_USAGE
        |VIEW_TABLE_USAGE
        |VIEWS
        |all_columns
        |all_objects
        |all_parameters
        |all_sql_modules
        |all_views
        |allocation_units
        |assemblies
        |assembly_files
        |assembly_modules
        |assembly_references
        |assembly_types
        |asymmetric_keys
        |backup_devices
        |certificates
        |change_tracking_databases
        |change_tracking_tables
        |check_constraints
        |column_type_usages
        |column_xml_schema_collection_usages
        |columns
        |computed_columns
        |configurations
        |conversation_endpoints
        |conversation_groups
        |conversation_priorities
        |credentials
        |crypt_properties
        |cryptographic_providers
        |data_spaces
        |database_audit_specification_details
        |database_audit_specifications
        |database_files
        |database_mirroring
        |database_mirroring_endpoints
        |database_permissions
        |database_principal_aliases
        |database_principals
        |database_recovery_status
        |database_role_members
        |databases
        |default_constraints
        |destination_data_spaces
        |dm_audit_actions
        |dm_audit_class_type_map
        |dm_broker_activated_tasks
        |dm_broker_connections
        |dm_broker_forwarded_messages
        |dm_broker_queue_monitors
        |dm_cdc_errors
        |dm_cdc_log_scan_sessions
        |dm_clr_appdomains
        |dm_clr_loaded_assemblies
        |dm_clr_properties
        |dm_clr_tasks
        |dm_cryptographic_provider_properties
        |dm_database_encryption_keys
        |dm_db_file_space_usage
        |dm_db_index_usage_stats
        |dm_db_mirroring_auto_page_repair
        |dm_db_mirroring_connections
        |dm_db_mirroring_past_actions
        |dm_db_missing_index_details
        |dm_db_missing_index_group_stats
        |dm_db_missing_index_groups
        |dm_db_partition_stats
        |dm_db_persisted_sku_features
        |dm_db_script_level
        |dm_db_session_space_usage
        |dm_db_task_space_usage
        |dm_exec_background_job_queue
        |dm_exec_background_job_queue_stats
        |dm_exec_cached_plans
        |dm_exec_connections
        |dm_exec_procedure_stats
        |dm_exec_query_memory_grants
        |dm_exec_query_optimizer_info
        |dm_exec_query_resource_semaphores
        |dm_exec_query_stats
        |dm_exec_query_transformation_stats
        |dm_exec_requests
        |dm_exec_sessions
        |dm_exec_trigger_stats
        |dm_filestream_file_io_handles
        |dm_filestream_file_io_requests
        |dm_fts_active_catalogs
        |dm_fts_fdhosts

t/common-sqlserver.t  view on Meta::CPAN

        |fulltext_catalogs
        |fulltext_document_types
        |fulltext_index_catalog_usages
        |fulltext_index_columns
        |fulltext_index_fragments
        |fulltext_indexes
        |fulltext_languages
        |fulltext_stoplists
        |fulltext_stopwords
        |fulltext_system_stopwords
        |function_order_columns
        |http_endpoints
        |identity_columns
        |index_columns
        |indexes
        |internal_tables
        |key_constraints
        |key_encryptions
        |linked_logins
        |login_token
        |master_files
        |master_key_passwords
        |message_type_xml_schema_collection_usages
        |messages
        |module_assembly_usages
        |numbered_procedure_parameters
        |numbered_procedures
        |objects
        |openkeys
        |parameter_type_usages
        |parameter_xml_schema_collection_usages
        |parameters
        |partition_functions
        |partition_parameters
        |partition_range_values
        |partition_schemes
        |partitions
        |plan_guides
        |procedures
        |remote_logins
        |remote_service_bindings
        |resource_governor_configuration
        |resource_governor_resource_pools
        |resource_governor_workload_groups
        |routes
        |schemas
        |securable_classes
        |server_assembly_modules
        |server_audit_specification_details
        |server_audit_specifications
        |server_audits
        |server_event_notifications
        |server_event_session_actions
        |server_event_session_events
        |server_event_session_fields
        |server_event_session_targets
        |server_event_sessions
        |server_events
        |server_file_audits
        |server_permissions
        |server_principal_credentials
        |server_principals
        |server_role_members
        |server_sql_modules
        |server_trigger_events
        |server_triggers
        |servers
        |service_broker_endpoints
        |service_contract_message_usages
        |service_contract_usages
        |service_contracts
        |service_message_types
        |service_queue_usages
        |service_queues
        |services
        |soap_endpoints
        |spatial_index_tessellations
        |spatial_indexes
        |spatial_reference_systems
        |sql_dependencies
        |sql_logins
        |sql_modules
        |stats
        |stats_columns
        |symmetric_keys
        |synonyms
        |syscacheobjects
        |syscharsets
        |syscolumns
        |syscomments
        |sysconfigures
        |sysconstraints
        |syscurconfigs
        |syscursorcolumns
        |syscursorrefs
        |syscursors
        |syscursortables
        |sysdatabases
        |sysdepends
        |sysdevices
        |sysfilegroups
        |sysfiles
        |sysforeignkeys
        |sysfulltextcatalogs
        |sysindexes
        |sysindexkeys
        |syslanguages
        |syslockinfo
        |syslogins
        |sysmembers
        |sysmessages
        |sysobjects
        |sysoledbusers
        |sysopentapes
        |sysperfinfo
        |syspermissions
        |sysprocesses
        |sysprotects
        |sysreferences
        |sysremotelogins
        |sysservers