Tablas de sistema

[CID]

Hola.
Necesito acceder a las tablas de sistema de las bases de datos mysql.
Como se llaman esas tablas?

Código

SELECT *
FROM TABLASISTEMA -- esta seria una tabla de sistema
 

Saludos

[CID]

En interbase se hace una consulta como la de arriba.
Pero aca en mysql encontré ésto que parece cumple con lo buscado... aunque voy a necesitar TODAS la tablas de sistema.

Código

DESC TABLAUSUARIO

Asi que si conocen la lista completa de "comandos" mysql ponganlos aca por favor.

[CID]

Bueno, por si a alguien le interesa:

Código

-- 
-- Base de datos: 'information_schema'
-- 
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'CHARACTER_SETS'
-- 
 
CREATE TEMPORARY TABLE CHARACTER_SETS (
  CHARACTER_SET_NAME varchar(64) NOT NULL DEFAULT '',
  DEFAULT_COLLATE_NAME varchar(64) NOT NULL DEFAULT '',
  DESCRIPTION varchar(60) NOT NULL DEFAULT '',
  MAXLEN bigint(3) NOT NULL DEFAULT '0'
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'COLLATIONS'
-- 
 
CREATE TEMPORARY TABLE COLLATIONS (
  COLLATION_NAME varchar(64) NOT NULL DEFAULT '',
  CHARACTER_SET_NAME varchar(64) NOT NULL DEFAULT '',
  ID bigint(11) NOT NULL DEFAULT '0',
  IS_DEFAULT varchar(3) NOT NULL DEFAULT '',
  IS_COMPILED varchar(3) NOT NULL DEFAULT '',
  SORTLEN bigint(3) NOT NULL DEFAULT '0'
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'COLLATION_CHARACTER_SET_APPLICABILITY'
-- 
 
CREATE TEMPORARY TABLE COLLATION_CHARACTER_SET_APPLICABILITY (
  COLLATION_NAME varchar(64) NOT NULL DEFAULT '',
  CHARACTER_SET_NAME varchar(64) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'COLUMNS'
-- 
 
CREATE TEMPORARY TABLE `COLUMNS` (
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  COLUMN_NAME varchar(64) NOT NULL DEFAULT '',
  ORDINAL_POSITION bigint(21) NOT NULL DEFAULT '0',
  COLUMN_DEFAULT varchar(64) DEFAULT NULL,
  IS_NULLABLE varchar(3) NOT NULL DEFAULT '',
  DATA_TYPE varchar(64) NOT NULL DEFAULT '',
  CHARACTER_MAXIMUM_LENGTH bigint(21) DEFAULT NULL,
  CHARACTER_OCTET_LENGTH bigint(21) DEFAULT NULL,
  NUMERIC_PRECISION bigint(21) DEFAULT NULL,
  NUMERIC_SCALE bigint(21) DEFAULT NULL,
  CHARACTER_SET_NAME varchar(64) DEFAULT NULL,
  COLLATION_NAME varchar(64) DEFAULT NULL,
  COLUMN_TYPE longtext NOT NULL,
  COLUMN_KEY varchar(3) NOT NULL DEFAULT '',
  EXTRA varchar(20) NOT NULL DEFAULT '',
  `PRIVILEGES` varchar(80) NOT NULL DEFAULT '',
  COLUMN_COMMENT varchar(255) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'COLUMN_PRIVILEGES'
-- 
 
CREATE TEMPORARY TABLE COLUMN_PRIVILEGES (
  GRANTEE varchar(81) NOT NULL DEFAULT '',
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  COLUMN_NAME varchar(64) NOT NULL DEFAULT '',
  PRIVILEGE_TYPE varchar(64) NOT NULL DEFAULT '',
  IS_GRANTABLE varchar(3) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'KEY_COLUMN_USAGE'
-- 
 
CREATE TEMPORARY TABLE KEY_COLUMN_USAGE (
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  COLUMN_NAME varchar(64) NOT NULL DEFAULT '',
  ORDINAL_POSITION bigint(10) NOT NULL DEFAULT '0',
  POSITION_IN_UNIQUE_CONSTRAINT bigint(10) DEFAULT NULL,
  REFERENCED_TABLE_SCHEMA varchar(64) DEFAULT NULL,
  REFERENCED_TABLE_NAME varchar(64) DEFAULT NULL,
  REFERENCED_COLUMN_NAME varchar(64) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'ROUTINES'
-- 
 
CREATE TEMPORARY TABLE ROUTINES (
  SPECIFIC_NAME varchar(64) NOT NULL DEFAULT '',
  ROUTINE_CATALOG varchar(512) DEFAULT NULL,
  ROUTINE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  ROUTINE_NAME varchar(64) NOT NULL DEFAULT '',
  ROUTINE_TYPE varchar(9) NOT NULL DEFAULT '',
  DTD_IDENTIFIER varchar(64) DEFAULT NULL,
  ROUTINE_BODY varchar(8) NOT NULL DEFAULT '',
  ROUTINE_DEFINITION longtext NOT NULL,
  EXTERNAL_NAME varchar(64) DEFAULT NULL,
  EXTERNAL_LANGUAGE varchar(64) DEFAULT NULL,
  PARAMETER_STYLE varchar(8) NOT NULL DEFAULT '',
  IS_DETERMINISTIC varchar(3) NOT NULL DEFAULT '',
  SQL_DATA_ACCESS varchar(64) NOT NULL DEFAULT '',
  SQL_PATH varchar(64) DEFAULT NULL,
  SECURITY_TYPE varchar(7) NOT NULL DEFAULT '',
  CREATED datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  LAST_ALTERED datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  SQL_MODE longtext NOT NULL,
  ROUTINE_COMMENT varchar(64) NOT NULL DEFAULT '',
  `DEFINER` varchar(77) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'SCHEMATA'
-- 
 
CREATE TEMPORARY TABLE SCHEMATA (
  CATALOG_NAME varchar(512) DEFAULT NULL,
  SCHEMA_NAME varchar(64) NOT NULL DEFAULT '',
  DEFAULT_CHARACTER_SET_NAME varchar(64) NOT NULL DEFAULT '',
  DEFAULT_COLLATION_NAME varchar(64) NOT NULL DEFAULT '',
  SQL_PATH varchar(512) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'SCHEMA_PRIVILEGES'
-- 
 
CREATE TEMPORARY TABLE SCHEMA_PRIVILEGES (
  GRANTEE varchar(81) NOT NULL DEFAULT '',
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  PRIVILEGE_TYPE varchar(64) NOT NULL DEFAULT '',
  IS_GRANTABLE varchar(3) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'STATISTICS'
-- 
 
CREATE TEMPORARY TABLE STATISTICS (
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  NON_UNIQUE bigint(1) NOT NULL DEFAULT '0',
  INDEX_SCHEMA varchar(64) NOT NULL DEFAULT '',
  INDEX_NAME varchar(64) NOT NULL DEFAULT '',
  SEQ_IN_INDEX bigint(2) NOT NULL DEFAULT '0',
  COLUMN_NAME varchar(64) NOT NULL DEFAULT '',
  `COLLATION` varchar(1) DEFAULT NULL,
  CARDINALITY bigint(21) DEFAULT NULL,
  SUB_PART bigint(3) DEFAULT NULL,
  PACKED varchar(10) DEFAULT NULL,
  NULLABLE varchar(3) NOT NULL DEFAULT '',
  INDEX_TYPE varchar(16) NOT NULL DEFAULT '',
  `COMMENT` varchar(16) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'TABLES'
-- 
 
CREATE TEMPORARY TABLE `TABLES` (
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  TABLE_TYPE varchar(64) NOT NULL DEFAULT '',
  `ENGINE` varchar(64) DEFAULT NULL,
  VERSION bigint(21) DEFAULT NULL,
  `ROW_FORMAT` varchar(10) DEFAULT NULL,
  TABLE_ROWS bigint(21) DEFAULT NULL,
  `AVG_ROW_LENGTH` bigint(21) DEFAULT NULL,
  DATA_LENGTH bigint(21) DEFAULT NULL,
  MAX_DATA_LENGTH bigint(21) DEFAULT NULL,
  INDEX_LENGTH bigint(21) DEFAULT NULL,
  DATA_FREE bigint(21) DEFAULT NULL,
  `AUTO_INCREMENT` bigint(21) DEFAULT NULL,
  CREATE_TIME datetime DEFAULT NULL,
  UPDATE_TIME datetime DEFAULT NULL,
  CHECK_TIME datetime DEFAULT NULL,
  TABLE_COLLATION varchar(64) DEFAULT NULL,
  `CHECKSUM` bigint(21) DEFAULT NULL,
  CREATE_OPTIONS varchar(255) DEFAULT NULL,
  TABLE_COMMENT varchar(80) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'TABLE_CONSTRAINTS'
-- 
 
CREATE TEMPORARY TABLE TABLE_CONSTRAINTS (
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  CONSTRAINT_TYPE varchar(64) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'TABLE_PRIVILEGES'
-- 
 
CREATE TEMPORARY TABLE TABLE_PRIVILEGES (
  GRANTEE varchar(81) NOT NULL DEFAULT '',
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  PRIVILEGE_TYPE varchar(64) NOT NULL DEFAULT '',
  IS_GRANTABLE varchar(3) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'TRIGGERS'
-- 
 
CREATE TEMPORARY TABLE `TRIGGERS` (
  TRIGGER_CATALOG varchar(512) DEFAULT NULL,
  TRIGGER_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TRIGGER_NAME varchar(64) NOT NULL DEFAULT '',
  EVENT_MANIPULATION varchar(6) NOT NULL DEFAULT '',
  EVENT_OBJECT_CATALOG varchar(512) DEFAULT NULL,
  EVENT_OBJECT_SCHEMA varchar(64) NOT NULL DEFAULT '',
  EVENT_OBJECT_TABLE varchar(64) NOT NULL DEFAULT '',
  ACTION_ORDER bigint(4) NOT NULL DEFAULT '0',
  ACTION_CONDITION longtext,
  ACTION_STATEMENT longtext NOT NULL,
  ACTION_ORIENTATION varchar(9) NOT NULL DEFAULT '',
  ACTION_TIMING varchar(6) NOT NULL DEFAULT '',
  ACTION_REFERENCE_OLD_TABLE varchar(64) DEFAULT NULL,
  ACTION_REFERENCE_NEW_TABLE varchar(64) DEFAULT NULL,
  ACTION_REFERENCE_OLD_ROW varchar(3) NOT NULL DEFAULT '',
  ACTION_REFERENCE_NEW_ROW varchar(3) NOT NULL DEFAULT '',
  CREATED datetime DEFAULT NULL,
  SQL_MODE longtext NOT NULL,
  `DEFINER` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'USER_PRIVILEGES'
-- 
 
CREATE TEMPORARY TABLE USER_PRIVILEGES (
  GRANTEE varchar(81) NOT NULL DEFAULT '',
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  PRIVILEGE_TYPE varchar(64) NOT NULL DEFAULT '',
  IS_GRANTABLE varchar(3) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
-- 
-- Estructura de tabla para la tabla 'VIEWS'
-- 
 
CREATE TEMPORARY TABLE VIEWS (
  TABLE_CATALOG varchar(512) DEFAULT NULL,
  TABLE_SCHEMA varchar(64) NOT NULL DEFAULT '',
  TABLE_NAME varchar(64) NOT NULL DEFAULT '',
  VIEW_DEFINITION longtext NOT NULL,
  CHECK_OPTION varchar(8) NOT NULL DEFAULT '',
  IS_UPDATABLE varchar(3) NOT NULL DEFAULT '',
  `DEFINER` varchar(77) NOT NULL DEFAULT '',
  SECURITY_TYPE varchar(7) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- 
-- Filtros para las tablas descargadas (dump)
-- 
 
-- 
-- Filtros para la tabla `KEY_COLUMN_USAGE`
-- 
ALTER TABLE `KEY_COLUMN_USAGE`
  ADD CONSTRAINT_CATALOG varchar(512) DEFAULT NULL,
  ADD CONSTRAINT_SCHEMA varchar(64) NOT NULL DEFAULT '',
  ADD CONSTRAINT_NAME varchar(64) NOT NULL DEFAULT '',;
 
-- 
-- Filtros para la tabla `TABLE_CONSTRAINTS`
-- 
ALTER TABLE `TABLE_CONSTRAINTS`
  ADD CONSTRAINT_CATALOG varchar(512) DEFAULT NULL,
  ADD CONSTRAINT_SCHEMA varchar(64) NOT NULL DEFAULT '',
  ADD CONSTRAINT_NAME varchar(64) NOT NULL DEFAULT '',;
 

Esas son las tablas de sistema de MySql.

Saludos.