Send feedback on this topic.
Teradata.Client.Provider
Entity Functions Schema
.NET Data Provider for Teradata > Developer's Guide > ADO.NET Entity Provider for Teradata > Entity Provider Store Schemas > Entity Provider Store Schema Collection > Entity Functions Schema
.NET CORE   This feature is not supported by the .NET Core implementation of the Data Provider.

The Functions schema returns information about USER DEFINED FUNCTION objects by accessing the Advanced SQL Engine Data Dictionary views. It will access DBC.TABLES[V] or DBC.TABLES[V]X Data Dictionary view based on UseXViews Connection setting.

Column Name Data Type Description
Id String Returns a unique Id for the FUNCTION.
CatalogName String This field is always set to NULL.
SchemaName String Returns the name of the DATABASE in which the FUNCTION object resides.
Name String Returns the name of the FUNCTION.
Parameters EntityCollection<Parameter>  
Parameter.ID String Returns the Id of the parameter.
Parameter.Name String Returns the name of the parameter.
Parameter.Mode String Returns information about the parameter mode:

  • IN
  • OUT
  • INOUT
Parameter.Default String Returns any default value assigned to the parameter.
Parameter.Ordinal Int32 Returns the position of the parameter.
Parameter.ParameterType TypeSpecification  
Parameter.ParameterType.TypeName String Returns the SQL Data Type name. TypeName will return the User Defined Type name if the column is a UDT.
Parameter.ParameterType.MaxLength Int32? Returns the maximum length of the Column for the following Data Types:

  • BYTE or VARBYTE
  • CHAR or VARCHAR
  • BLOB or CLOB
  • All Interval Data Types
  • All Period Types
Parameter.ParameterType.Precision Int32? Returns information about the maximum number of digits (base 10) that can be stored in a Numeric data type:

  • ByteInt, SmallInt, Integer and BigInt
  • Decimal or Numeric
  • Float or Double Precision
Parameter.ParameterType.DateTimePrecision Int32? Returns information about the maximum numbers of fractional seconds to the right of the decimal point for the following data types:

  • Timestamp and Timestamp With Time Zone
  • Time and Time With Time Zone
  • Interval Day To Second
  • Interval Hour To Second
  • Interval Minute To Second
  • Interval Second
Parameter.ParameterType.Scale Int32? Returns information about the maximum number of fractional digits (base 10) to the right of the decimal point for Decimal data type.
IsBuiltIn Boolean? This field is always set to False.
IsNiladic Boolean? This field is always set to False.

 

 

© 2005-2019 Teradata. All rights reserved.