Share via

2.1.2.4 F391, Long identifiers

  • Article

V0010:

The specification states the following:

 Subclause 5.2, "INFORMATION_SCHEMA_CATALOG_NAME base table":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.INFORMATION_SCHEMA_CATALOG_NAME.
  
 Function
  
 Identify the catalog that contains the Information Schema.
  
 Subclause 5.8, "ADMINISTRABLE_ROLE_AUTHORIZATIONS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ADMINISTRABLE_ROLE_AUTHORIZATIONS.
  
 Function
  
 Identify role authorizations for which the current user or role has WITH ADMIN OPTION.
  
 Subclause 5.11, "ATTRIBUTES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ATTRIBUTES.
  
 Function
  
 Identify the attributes of user-defined types defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.12, "CHARACTER_SETS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.CHARACTER_SETS.
  
 Function
  
 Identify the character sets defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.13, "CHECK_CONSTRAINT_ROUTINE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.CHECK_CONSTRAINT_ROUTINE_USAGE.
  
 Function
  
 Identify each SQL-invoked routine owned by a given user or role on which a domain constraint, table check constraint or assertion defined in this catalog is dependent.
  
  
  
 Subclause 5.15, "COLLATIONS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.COLLATIONS.
  
 Function
  
 Identify the character collations defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.16, "COLLATION_CHARACTER_SET_APPLICABILITY view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY.
  
 Function
  
 Identify the character sets to which each collation is applicable.
  
 Subclause 5.17, "COLUMN_COLUMN_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.COLUMN_COLUMN_USAGE.
  
 Function 
  
 Identify each case where a generated column depends on a base column in a base table owned by a given user or role.
  
 Subclause 5.18, "COLUMN_DOMAIN_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE.
  
 Function
  
 Identify the columns defined that are dependent on a domain defined in this catalog and owned by a user or role.
  
 Subclause 5.21, "COLUMNS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.COLUMNS.
  
 Function
  
 Identify the columns of tables defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.22, "CONSTRAINT_COLUMN_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE.
  
 Function
  
 Identify the columns used by referential constraints, unique constraints, check constraints, and assertions defined in this catalog and owned by a given user or role.
  
 Subclause 5.24, "CONSTRAINT_TABLE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE.
  
 Function
  
 Identify the tables that are used by referential constraints, unique constraints, check constraints, and assertions defined in this catalog and owned by a given user or role.
  
 Subclause 5.29, "DOMAINS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.DOMAINS.
  
 Function
  
 Identify the domains defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.30, "ELEMENT_TYPES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ELEMENT_TYPES.
  
 Function
  
 Identify the collection element types defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.32, "FIELDS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.FIELDS.
  
 Function
  
 Identify the field types defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.33, "KEY_COLUMN_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.KEY_COLUMN_USAGE.
  
 Function
  
 Identify the columns defined in this catalog that are constrained as keys and that are accessible by a given user or role.
  
 Subclause 5.35, "METHOD_SPECIFICATION_PARAMETERS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.METHOD_SPECIFICATION_PARAMETERS.
  
 Function
  
 Identify the SQL parameters of method specifications described in the METHOD_SPECIFICATIONS view that are accessible to a given user or role.
  
 Subclause 5.36, "METHOD_SPECIFICATIONS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.METHOD_SPECIFICATIONS.
  
 Function
  
 Identify the SQL-invoked methods in the catalog that are accessible to a given user or role.
  
 Subclause 5.37, "PARAMETERS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.PARAMETERS.
  
 Function
  
 Identify the SQL parameters of SQL-invoked routines defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.39, "REFERENCED_TYPES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.REFERENCED_TYPES.
  
 Function
  
 Identify the referenced types of reference types defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.40, "REFERENTIAL_CONSTRAINTS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS.
  
 Function
  
 Identify the referential constraints defined on tables in this catalog that are accssible to a given user or role.
  
 Subclause 5.42, "ROLE_ROUTINE_GRANTS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ROLE_ROUTINE_GRANTS.
  
 Function
  
 Identify the privileges on SQL-invoked routines defined in this catalog that are available to or granted by the currently enabled roles.
  
 Subclause 5.44, "ROLE_TABLE_METHOD_GRANTS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ROLE_TABLE_METHOD_GRANTS.
  
 Function
  
 Identify the privileges on methods of tables of structured types defined in this catalog that are available to or granted by the currently enabled roles.
  
 Subclause 5.47, "ROUTINE_COLUMN_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ROUTINE_COLUMN_USAGE.
  
 Function
  
 Identify the columns owned by a given user or role on which SQL routines defined in this catalog are dependent.
  
 Subclause 5.50, "ROUTINE_ROUTINE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ROUTINE_ROUTINE_USAGE.
  
 Function
  
 Identify each SQL-invoked routine owned by a given user or role on which an SQL routine defined in this catalog is dependent.
  
 Subclause 5.51, "ROUTINE_SEQUENCE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ROUTINE_SEQUENCE_USAGE.
  
 Function
  
 Identify each external sequence generator owned by a given user or role on which some SQL routine defined in this catalog is dependent.
  
 Subclause 5.52, "ROUTINE_TABLE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ROUTINE_TABLE_USAGE.
  
 Function
  
 Identify the tables owned by a given user or role on which SQL routines defined in this catalog are dependent.
  
 Subclause 5.53, "ROUTINES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.ROUTINES.
  
 Function
  
 Identify the SQL-invoked routines in this catalog that are accessible to a given user or role.
  
 Subclause 5.54, "SCHEMATA view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.SCHEMATA.
  
 Function
  
 Identify the schemata in a catalog that are owned by a given user or role.
  
 Subclause 5.55, "SEQUENCES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.SEQUENCES.
  
 Function
  
 Identify the external sequence generators defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.57, "SQL_IMPLEMENTATION_INFO view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_IMPLEMENTATION_INFO.
  
 Function
  
 List the SQL-implementation information items defined in this standard and, for each of these, indicate the value supported by the SQL-implementation.
  
 Subclause 5.61, "TABLE_METHOD_PRIVILEGES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TABLE_METHOD_PRIVILEGES.
  
 Function
  
 Identify the privileges on methods of tables of structured type defined in those catalogs that are available to or granted by a given user or role.
  
 Subclause 5.63, "TABLES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TABLES.
  
 Function
  
 Identify the tables defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.65, "TRANSLATIONS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TRANSLATIONS.
  
 Function
  
 Identify the character transliterations defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.66, "TRIGGERED_UPDATE_COLUMNS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TRIGGERED_UPDATE_COLUMNS.
  
 Function
  
 Identify the columns in this catalog that are identified by the explicit UPDATE trigger event columns of a trigger defined in this catalog that are accessible to a given user or role.
  
 Subclause 5.67, "TRIGGER_COLUMN_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TRIGGERED_COLUMN_USAGE.
  
 Function
  
 Identify the columns on which triggers defined in this catalog and owned by a given user are dependent because of their reference by the search condition or in their appearance in a triggered SQL statement of a trigger owned by a given user or role.
  
 Subclause 5.69, "TRIGGER_ROUTINE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TRIGGER_ROUTINE_USAGE.
  
 Function
  
 Identify each SQL-invoked routine owned by a given user or role on which some trigger defined in this catalog is dependent.
  
 Subclause 5.70, "TRIGGER_SEQUENCE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TRIGGER_SEQUENCE_USAGE.
  
 Function
  
 Identify each external sequence generator owned by a given user or role on which some trigger defined in this catalog is dependent.
  
 Subclause 5.71, "TRIGGER_TABLE_USAGE view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TRIGGER_TABLE_USAGE.
  
 Function
  
 Identify the tables on which triggers defined in this catalog and owned by a given user or role are dependent.
  
 Subclause 5.72, "TRIGGERS view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.TRIGGERS.
  
 Function
  
 Identify the triggers defined on tables in this catalog that are accessible to a given user or role.
  
 Subclause 5.75, "USER_DEFINED_TYPES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.USER_DEFINED_TYPES.
  
 Function
  
 Identify the user-defined types defined in this catalog that are accessible to a given user or role.

The following additional subclause is present in the [ISO/IEC9075-11:2008] specification:

 Subclause 5.57, "SQL_SIZING_PROFILES view":
  
 Without Feature F391, "Long identifiers", conforming SQL language shall not reference INFORMATION_SCHEMA.SQL_SIZING_PROFILES.
  
 Function
  
 List the sizing items defined in this standard and, for each of these, indicate the size required by one or more profiles of the standard.

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL partially supports this feature. Only the COLUMN_DOMAIN_USAGE, COLUMNS, CONSTRAINT_COLUMN_USAGE, CONSTRAINT_TABLE_USAGE, DOMAINS, KEY_COLUMN_USAGE, PARAMETERS, REFERENTIAL CONSTRAINTS, ROUTINES, SCHEMATA, and TABLES views are supported.