What is true about the contents of the INFORMATION_SCHEMATA table?

What is true about the contents of the INFORMATION_SCHEMATA table?

What is true about the contents of the INFORMATION_SCHEMATA table?

A.
It contains information about the table structure for all databases.

B.
It contains information about all the tables, triggers, and views for all databases.

C.
It contains information such as name, character set, and collation for all the databases on
the server.

D.
It contains information including tables, trigger, stored routines, and views for all
databases

Explanation:
Reference:
http://www.mssqltips.com/sqlservertutorial/196/informationschematables/ (overview)



Leave a Reply 8

Your email address will not be published. Required fields are marked *


Jay

Jay

B

From my Database:

It shows Tables, Triggers, and Views.
… character set, and collation but nothing about name.

select table_name from INFORMATION_SCHEMA.tables
where table_schema = ‘information_schema’;

table_name
‘CHARACTER_SETS’
‘COLLATIONS’
‘COLLATION_CHARACTER_SET_APPLICABILITY’
‘COLUMNS’
‘COLUMN_PRIVILEGES’
‘ENGINES’
‘EVENTS’
‘FILES’
‘GLOBAL_STATUS’
‘GLOBAL_VARIABLES’
‘KEY_COLUMN_USAGE’
‘OPTIMIZER_TRACE’
‘PARAMETERS’
‘PARTITIONS’
‘PLUGINS’
‘PROCESSLIST’
‘PROFILING’
‘REFERENTIAL_CONSTRAINTS’
‘ROUTINES’
‘SCHEMATA’
‘SCHEMA_PRIVILEGES’
‘SESSION_STATUS’
‘SESSION_VARIABLES’
‘STATISTICS’
‘TABLES’
‘TABLESPACES’
‘TABLE_CONSTRAINTS’
‘TABLE_PRIVILEGES’
‘TRIGGERS’
‘USER_PRIVILEGES’
‘VIEWS’
‘INNODB_LOCKS’
‘INNODB_TRX’
‘INNODB_SYS_DATAFILES’
‘INNODB_LOCK_WAITS’
‘INNODB_SYS_TABLESTATS’
‘INNODB_CMP’
‘INNODB_METRICS’
‘INNODB_CMP_RESET’
‘INNODB_CMP_PER_INDEX’
‘INNODB_CMPMEM_RESET’
‘INNODB_FT_DELETED’
‘INNODB_BUFFER_PAGE_LRU’
‘INNODB_SYS_FOREIGN’
‘INNODB_SYS_COLUMNS’
‘INNODB_SYS_INDEXES’
‘INNODB_FT_DEFAULT_STOPWORD’
‘INNODB_SYS_FIELDS’
‘INNODB_CMP_PER_INDEX_RESET’
‘INNODB_BUFFER_PAGE’
‘INNODB_CMPMEM’
‘INNODB_FT_INDEX_TABLE’
‘INNODB_FT_BEING_DELETED’
‘INNODB_SYS_TABLESPACES’
‘INNODB_FT_INDEX_CACHE’
‘INNODB_SYS_FOREIGN_COLS’
‘INNODB_SYS_TABLES’
‘INNODB_BUFFER_POOL_STATS’
‘INNODB_FT_CONFIG’

Jay

Jay

C

Ops I read over the scheMATA part of the question.