Export (0) Print
Expand All

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace

 

Applies To: SQL Server 2016 Preview

The Microsoft.SqlServer.Management.SqlParser.Metadata namespace contains types designed to support the SQL Server parser.

ClassDescription
System_CAPS_pubclassCollationInfo

Provides information about a specific database collation.

System_CAPS_pubclassComputedColumnInfo

Provides the SQL Server computed column specification.

System_CAPS_pubclassDataTypeArgSpec

Represents a system data type numeric-argument specification.

System_CAPS_pubclassDataTypeSpec

Represents a built-in data type specification.

System_CAPS_pubclassIdentityColumnInfo

Provides the SQL Server identity column specification.

System_CAPS_pubclassTriggerEventTypeSet

Represents a set of DDL trigger event types.

InterfaceDescription
System_CAPS_pubinterfaceIApplicationRole

Represents a SQL Server security role that enables an application to run with its own, user-like permissions.

System_CAPS_pubinterfaceIAsymmetricKey

Represents a SQL Server asymmetric key.

System_CAPS_pubinterfaceIBuiltInFunction

Represents a built-in function or a system function that starts with two at signs (@@).

System_CAPS_pubinterfaceICallableModule

Represents a SQL Server callable module, such as a stored procedure or a scalar-valued function.

System_CAPS_pubinterfaceICertificate

Represents a SQL Server certificate.

System_CAPS_pubinterfaceICheckConstraint

Represents a CHECK constraint.

System_CAPS_pubinterfaceIClrDataType

Represents a user-defined CLR data type (UDT).

System_CAPS_pubinterfaceICollation

Represents a SQL Server collation.

System_CAPS_pubinterfaceIColumn

Represents a SQL Server column.

System_CAPS_pubinterfaceIConstraint

Represents a tabular object constraints.

System_CAPS_pubinterfaceICredential

Represents a SQL Server credential.

System_CAPS_pubinterfaceICursorDataType

Represents a SQL Server cursor data type.

System_CAPS_pubinterfaceICursorParameter

Represents a parameter of a cursor type.

System_CAPS_pubinterfaceICursorVariable

Represents a cursor type variable.

System_CAPS_pubinterfaceIDatabase

Represents a SQL Server database. 

System_CAPS_pubinterfaceIDatabaseDdlTrigger

Represents a database DDL trigger.

System_CAPS_pubinterfaceIDatabaseObject

Defines methods and properties that are common to all database objects.

System_CAPS_pubinterfaceIDatabaseObjectVisitor<T>

Represents a database object visitor.

System_CAPS_pubinterfaceIDatabaseOwnedObject

Represents a metadata object that is owned by an IDatabase object.

System_CAPS_pubinterfaceIDatabaseOwnedObjectVisitor<T>

Represents a SQL Server database-owned object visitor.

System_CAPS_pubinterfaceIDatabasePermission

Represents a SQL Server database permission.

System_CAPS_pubinterfaceIDatabasePrincipal

Represents a SQL Server database-level principal object.

System_CAPS_pubinterfaceIDatabaseRole

Represents a SQL Server database security role.

System_CAPS_pubinterfaceIDatabaseTable

Represents a database table.

System_CAPS_pubinterfaceIDataType

Represents a SQL Server data type.

System_CAPS_pubinterfaceIDatePart

Represents a date-part built-in function argument (for example, hh, iso_week, and so on).

System_CAPS_pubinterfaceIDefaultConstraint

Represents a SQL Server default constraint.

System_CAPS_pubinterfaceIDmlTrigger

Represents a SQL Server DML trigger.

System_CAPS_pubinterfaceIExecutionContext

Represents a SQL Server user-defined module execution context.

System_CAPS_pubinterfaceIExtendedStoredProcedure

Represents a SQL Server extended stored procedure.

System_CAPS_pubinterfaceIFileGroup

Represents a SQL Server filegroup.

System_CAPS_pubinterfaceIForeignKeyColumn

Represents a SQL Server foreign key column.

System_CAPS_pubinterfaceIForeignKeyConstraint

Represents a SQL Server FOREIGN KEY constraint.

System_CAPS_pubinterfaceIFunction

Represents a SQL Server function.

System_CAPS_pubinterfaceIFunctionModuleBase

Common base interface for the IFunction and ICallableModule interfaces.

System_CAPS_pubinterfaceIIndex

Represents a SQL Server index.

System_CAPS_pubinterfaceIIndexedColumn

Represents a SQL Server column that is participating in an index.

System_CAPS_pubinterfaceILocalVariable

Defines a local variable or parameter.

System_CAPS_pubinterfaceILogin

Represents a SQL Server login.

System_CAPS_pubinterfaceIMetadataCollection<T>

Defines size, enumerators, lookup and filtering methods for all metadata object collections. The interface provides read-only access to the elements in the collection.

System_CAPS_pubinterfaceIMetadataObject

Represents a SQL Server metadata object.

System_CAPS_pubinterfaceIMetadataObjectVisitor<T>

Represents a SQL Server metadata object visitor.

System_CAPS_pubinterfaceIMetadataOrderedCollection<T>

Represents a collection of metadata objects where the element ordering is preserved.

System_CAPS_pubinterfaceIMutableApplicationRole

Represents a mutable SQL Server security role that enables an application to run with its own, user-like permissions.

System_CAPS_pubinterfaceIMutableAsymmetricKey

Represents a mutable SQL Server asymmetric key.

System_CAPS_pubinterfaceIMutableCallableModule

Represents a mutable SQL Server callable module, such as a stored procedure or a scalar-valued function.

System_CAPS_pubinterfaceIMutableCertificate

Represents a mutable SQL Server certificate.

System_CAPS_pubinterfaceIMutableCheckConstraint

Represents a mutable SQL Server CHECK constraint.

System_CAPS_pubinterfaceIMutableClrDataType

Represents mutable user-defined CLR data type (UDT).

System_CAPS_pubinterfaceIMutableColumn

Represents a mutable SQL Server column.

System_CAPS_pubinterfaceIMutableConstraint

Represents tabular object mutable constraints.

System_CAPS_pubinterfaceIMutableCredential

Represents a mutable SQL Server credential.

System_CAPS_pubinterfaceIMutableDatabase

Represents a mutable SQL Server database. 

System_CAPS_pubinterfaceIMutableDatabaseDdlTrigger

Represents a mutable database DDL trigger.

System_CAPS_pubinterfaceIMutableDatabaseObject

Defines methods and properties that are common to all mutable database objects.

System_CAPS_pubinterfaceIMutableDatabaseOwnedObject

Represents a mutable metadata object that is owned by an IDatabase object.

System_CAPS_pubinterfaceIMutableDatabasePermission

Represents a mutable SQL Server database permission.

System_CAPS_pubinterfaceIMutableDatabasePrincipal

Represents a mutable SQL Server database-level principal object.

System_CAPS_pubinterfaceIMutableDatabaseRole

Represents a mutable SQL Server database security role.

System_CAPS_pubinterfaceIMutableDatabaseTable

Represents a database table.

System_CAPS_pubinterfaceIMutableDataType

Represents a mutable SQL Server data type.

System_CAPS_pubinterfaceIMutableDefaultConstraint

Represents a mutable SQL Server default constraint.

System_CAPS_pubinterfaceIMutableDmlTrigger

Represents a mutable SQL Server DML trigger.

System_CAPS_pubinterfaceIMutableForeignKeyConstraint

Represents a mutable SQL Server FOREIGN KEY constraint.

System_CAPS_pubinterfaceIMutableFunction

Represents a mutable SQL Server function. 

System_CAPS_pubinterfaceIMutableFunctionModuleBase

Common base interface for the IMutableFunction and IMutableCallableModule interfaces.

System_CAPS_pubinterfaceIMutableIndex

Represents a mutable SQL Server index.

System_CAPS_pubinterfaceIMutableIndexedColumn

Represents a mutable SQL Server column that is participating in an index.

System_CAPS_pubinterfaceIMutableLogin

Represents a mutable SQL Server login.

System_CAPS_pubinterfaceIMutableMetadataCollection<T>

Defines methods to manipulate collections of objects that implement the IMetadataObject interface.

System_CAPS_pubinterfaceIMutableMetadataObject

Defines common interface of all mutable metadata objects.

System_CAPS_pubinterfaceIMutableMetadataOrderedCollection<T>

Represents a mutable collection of metadata objects where the element ordering is preserved.

System_CAPS_pubinterfaceIMutablePassword

Represents a mutable SQL Server login password.

System_CAPS_pubinterfaceIMutableRelationalIndex

Represents a mutable SQL Server relational index.

System_CAPS_pubinterfaceIMutableScalar

Represents a mutable scalar metadata object.

System_CAPS_pubinterfaceIMutableScalarDataType

Represents a mutable SQL Server scalar data type.

System_CAPS_pubinterfaceIMutableScalarFunction

Represents a mutable SQL Server scalar function.

System_CAPS_pubinterfaceIMutableScalarValuedFunction

Represents a mutable SQL Server scalar-valued function.

System_CAPS_pubinterfaceIMutableSchema

Represents a mutable SQL Server schema.

System_CAPS_pubinterfaceIMutableSchemaOwnedObject

Represents a mutable metadata object that is owned by a schema.

System_CAPS_pubinterfaceIMutableServer

Represents a mutable instance of SQL Server.

System_CAPS_pubinterfaceIMutableServerDdlTrigger

Represents a mutable SQL Server DDL trigger.

System_CAPS_pubinterfaceIMutableServerOwnedObject

Represents a mutable metadata object that is owned by an IServer object.

System_CAPS_pubinterfaceIMutableSpatialIndex

Represents a SQL Server spatial index.

System_CAPS_pubinterfaceIMutableStatistics

Represents a SQL Server statistics object.

System_CAPS_pubinterfaceIMutableStoredProcedure

Represents a mutable SQL Server stored procedure.

System_CAPS_pubinterfaceIMutableSynonym

Represents a mutable synonym.

System_CAPS_pubinterfaceIMutableTable

Represents a mutable SQL Server database table.

System_CAPS_pubinterfaceIMutableTableDataType

Represents a mutable SQL Server table data type.

System_CAPS_pubinterfaceIMutableTableValuedFunction

Represents a mutable SQL Server table-valued function.

System_CAPS_pubinterfaceIMutableTableViewBase

Base interface for the IMutableTable and IMutableView interfaces.

System_CAPS_pubinterfaceIMutableTabular

Defines a mutable interface for tabular metadata objects.

System_CAPS_pubinterfaceIMutableTrigger

Represents a mutable SQL Server trigger.

System_CAPS_pubinterfaceIMutableTriggerEventTypeSet

Represents a set of mutable trigger events.

System_CAPS_pubinterfaceIMutableUser

Represents a mutable SQL Server user.

System_CAPS_pubinterfaceIMutableUserDefinedClrType

Represents a mutable SQL Server user-defined CLR type (UDT).

System_CAPS_pubinterfaceIMutableUserDefinedDataType

Represents a mutable user-defined data type.

System_CAPS_pubinterfaceIMutableUserDefinedFunction

Represents a mutable user-defined function.

System_CAPS_pubinterfaceIMutableUserDefinedFunctionModuleBase

Common base interface for the IMutableUserDefinedFunction and IMutableCallableModule interfaces.

System_CAPS_pubinterfaceIMutableUserDefinedTableType

Represents a mutable user-defined table type.

System_CAPS_pubinterfaceIMutableUserDefinedType

Defines a common interface for all mutable user-defined types. These types include user-defined data types, user-defined table types, and user-defined CLR types.

System_CAPS_pubinterfaceIMutableView

Represents a mutable SQL Server database view. 

System_CAPS_pubinterfaceIMutableVirtualTable

Represents a mutable virtual table (a table that is not database-persisted).

System_CAPS_pubinterfaceIParameter

Represents a SQL Server parameter.

System_CAPS_pubinterfaceIPartitionScheme

Represents a SQL Server partition scheme.

System_CAPS_pubinterfaceIPassword

Represents a SQL Server login password.

System_CAPS_pubinterfaceIPrimaryKeyConstraint

Represents a SQL Server PRIMARY KEY constraint.

System_CAPS_pubinterfaceIRelationalIndex

Represents a SQL Server relational index.

System_CAPS_pubinterfaceIResolvedExtendedStoredProcedureSynonym

Represents a synonym resolved to an extended stored procedure.

System_CAPS_pubinterfaceIResolvedScalarValuedFunctionSynonym

Represents a synonym resolved to a scalar valued function.

System_CAPS_pubinterfaceIResolvedStoredProcedureSynonym

Represents a synonym resolved to a stored procedure.

System_CAPS_pubinterfaceIResolvedSynonym

Represents a resolved synonym.

System_CAPS_pubinterfaceIResolvedTableSynonym

Represents a synonym resolved to a table.

System_CAPS_pubinterfaceIResolvedTableValuedFunctionSynonym

Represents a synonym resolved to a table valued function.

System_CAPS_pubinterfaceIResolvedUserDefinedAggregateSynonym

Represents a synonym resolved to a user defined aggregate.

System_CAPS_pubinterfaceIResolvedViewSynonym

Represents a synonym resolved to a view.

System_CAPS_pubinterfaceIScalar

Represents a scalar metadata object.

System_CAPS_pubinterfaceIScalarDataType

Represents a SQL Server scalar data type.

System_CAPS_pubinterfaceIScalarExpression

Represents a scalar expression such as literals, for example: 1, 'hello', and so on; and the evaluation of scalar expressions, for example: 1 + 5, 12 * dbo.test('a'), and so on.

System_CAPS_pubinterfaceIScalarFunction

Represents a SQL Server scalar function.

System_CAPS_pubinterfaceIScalarParameter

Represents a SQL Server scalar parameter.

System_CAPS_pubinterfaceIScalarValuedFunction

Represents a SQL Server scalar-valued function.

System_CAPS_pubinterfaceIScalarVariable

Represents a SQL Server scalar variable.

System_CAPS_pubinterfaceISchema

Represents a SQL Server schema.

System_CAPS_pubinterfaceISchemaOwnedObject

Represents a metadata database object that is owned by a schema.

System_CAPS_pubinterfaceISchemaOwnedObjectVisitor<T>

Represents a SQL Server schema-owned object visitor.

System_CAPS_pubinterfaceIServer

Represents an instance of SQL Server.

System_CAPS_pubinterfaceIServerDdlTrigger

Represents a SQL Server DDL trigger. 

System_CAPS_pubinterfaceIServerOwnedObject

Represents a metadata object that is owned by an IServer object.

System_CAPS_pubinterfaceIServerOwnedObjectVisitor<T>

Represents a server-owned object visitor.

System_CAPS_pubinterfaceISpatialIndex

Represents a SQL Server spatial index.

System_CAPS_pubinterfaceIStatistics

Represents a SQL Server statistics object.

System_CAPS_pubinterfaceIStoredProcedure

Represents a SQL Server stored procedure. 

System_CAPS_pubinterfaceISynonym

Represents a SQL Server synonym object.

System_CAPS_pubinterfaceISystemClrDataType

Represents a SQL Server system CLR data type.

System_CAPS_pubinterfaceISystemDataType

Represents a SQL Server built-in system data type.

System_CAPS_pubinterfaceITable

Represents a SQL Server database table.

System_CAPS_pubinterfaceITableDataType

Represents a SQL Server table data type.

System_CAPS_pubinterfaceITableParameter

Represents a parameter of table type.

System_CAPS_pubinterfaceITableValuedFunction

Represents a SQL Server table-valued function.

System_CAPS_pubinterfaceITableVariable

Represents a SQL Server table variable. 

System_CAPS_pubinterfaceITableViewBase

Base interface for the ITable and IView interfaces.

System_CAPS_pubinterfaceITabular

Defines a common interface for all tabular metadata objects.

System_CAPS_pubinterfaceITrigger

Represents a SQL Server trigger.

System_CAPS_pubinterfaceITriggerEventTypeSet

Represents a set of trigger events.

System_CAPS_pubinterfaceIUdtDataMember

Represents a user-defined type property or field.

System_CAPS_pubinterfaceIUdtMember

Defines a common interface for all user-defined type members.

System_CAPS_pubinterfaceIUdtMethod

Represents a SQL Server user-defined type method.

System_CAPS_pubinterfaceIUniqueConstraint

Represents a SQL Server UNIQUE constraint.

System_CAPS_pubinterfaceIUniqueConstraintBase

Base interface for UNIQUE and PRIMARY KEY constraints.

System_CAPS_pubinterfaceIUser

Represents a SQL Server user.

System_CAPS_pubinterfaceIUserDefinedAggregate

Represents a SQL Server user-defined aggregate.

System_CAPS_pubinterfaceIUserDefinedClrType

Represents a SQL Server user-defined CLR type (UDT).

System_CAPS_pubinterfaceIUserDefinedDataType

Represents a user-defined data type.

System_CAPS_pubinterfaceIUserDefinedFunction

Represents a user-defined function.

System_CAPS_pubinterfaceIUserDefinedFunctionModuleBase

Common base interface for the IUserDefinedFunction and ICallableModule interfaces.

System_CAPS_pubinterfaceIUserDefinedTableType

Represents a user-defined table type.

System_CAPS_pubinterfaceIUserDefinedType

Defines a common interface for all user-defined types. These types include user-defined data types, user-defined table types, and user-defined CLR types.

System_CAPS_pubinterfaceIView

Represents a SQL Server database view. 

System_CAPS_pubinterfaceIVirtualTable

Represents a virtual table (a table that is not database-persisted).

System_CAPS_pubinterfaceIVoidDataType

Represents a void data type.

System_CAPS_pubinterfaceIXmlDataType

Represents the SQL Server xml data type.

System_CAPS_pubinterfaceIXmlDataTypeMethod

Represents a method that can be called on a scalar of the xml data type.

System_CAPS_pubinterfaceIXmlDataTypeTableMethod

Represents a table valued method that can be called on a scalar of the xml data type.

System_CAPS_pubinterfaceIXmlIndex

Represents a SQL Server XML index.

EnumerationDescription
System_CAPS_pubenumActivationOrder

Specifies the relative activation order of a trigger.

System_CAPS_pubenumCallableModuleType

Defines the callable module types.

System_CAPS_pubenumConstraintType

Specifies SQL Server constraint types.

System_CAPS_pubenumDatabasePermissionType

Specifies the SQL Server database permission types.

System_CAPS_pubenumExecutionContextType

Specifies the execution context for the user-defined module.

System_CAPS_pubenumForeignKeyAction

Specifies the action that is taken when the primary key that is referenced by a foreign key is updated.

System_CAPS_pubenumGridDensity

Specifies the grid density for a spatial index.

System_CAPS_pubenumIndexType

Indicates the type of the index.

System_CAPS_pubenumLoginType

Specifies the login type.

System_CAPS_pubenumPermissionState

Specifies SQL Server permission state.

System_CAPS_pubenumScalarType

Defines the scalar object types.

System_CAPS_pubenumSortOrder

Defines the item sort order.

System_CAPS_pubenumSqlDataType

Specifies the SQL Server built-in data type.

System_CAPS_pubenumStatisticsType

Indicates the type of the statistics.

System_CAPS_pubenumSynonymBaseType

Contains constant values that specify the type of synonym.

System_CAPS_pubenumTabularType

Defines a tabular object type.

System_CAPS_pubenumUserType

Specifies the user type.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft