Microsoft.SqlServer.Management.SqlParser.Metadata Namespace

  • Article

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

Classes

  Class Description
Public class CollationInfo Provides information about a specific database collation.
Public class ComputedColumnInfo Provides the SQL Server computed column specification.
Public class DataTypeArgSpec Represents a system data type numeric-argument specification.
Public class DataTypeSpec Represents a built-in data type specification.
Public class IdentityColumnInfo Provides the SQL Server identity column specification.
Public class TriggerEventTypeSet Represents a set of DDL trigger event types.

Interfaces

  Interface Description
Public interface IApplicationRole Represents a SQL Server security role that enables an application to run with its own, user-like permissions.
Public interface IAsymmetricKey Represents a SQL Server asymmetric key.
Public interface IBuiltInFunction Represents a built-in function or a system function that starts with two at signs (@@).
Public interface ICallableModule Represents a SQL Server callable module, such as a stored procedure or a scalar-valued function.
Public interface ICertificate Represents a SQL Server certificate.
Public interface ICheckConstraint Represents a CHECK constraint.
Public interface IClrDataType Represents a user-defined CLR data type (UDT).
Public interface ICollation Represents a SQL Server collation.
Public interface IColumn Represents a SQL Server column.
Public interface IConstraint Represents a tabular object constraints.
Public interface ICredential Represents a SQL Server credential.
Public interface ICursorDataType Represents a SQL Server cursor data type.
Public interface ICursorParameter Represents a parameter of a cursor type.
Public interface ICursorVariable Represents a cursor type variable.
Public interface IDatabase Represents a SQL Server database. 
Public interface IDatabaseDdlTrigger Represents a database DDL trigger.
Public interface IDatabaseObject Defines methods and properties that are common to all database objects.
Public interface IDatabaseObjectVisitor<T> Represents a database object visitor.
Public interface IDatabaseOwnedObject Represents a metadata object that is owned by an IDatabase object.
Public interface IDatabaseOwnedObjectVisitor<T> Represents a SQL Server database-owned object visitor.
Public interface IDatabasePermission Represents a SQL Server database permission.
Public interface IDatabasePrincipal Represents a SQL Server database-level principal object.
Public interface IDatabaseRole Represents a SQL Server database security role.
Public interface IDatabaseTable Represents a database table.
Public interface IDataType Represents a SQL Server data type.
Public interface IDatePart Represents a date-part built-in function argument (for example, hh, iso_week, and so on).
Public interface IDefaultConstraint Represents a SQL Server default constraint.
Public interface IDmlTrigger Represents a SQL Server DML trigger.
Public interface IExecutionContext Represents a SQL Server user-defined module execution context.
Public interface IExtendedStoredProcedure Represents a SQL Server extended stored procedure.
Public interface IFileGroup Represents a SQL Server filegroup.
Public interface IForeignKeyColumn Represents a SQL Server foreign key column.
Public interface IForeignKeyConstraint Represents a SQL Server FOREIGN KEY constraint.
Public interface IFunction Represents a SQL Server function.
Public interface IFunctionModuleBase Common base interface for the IFunction and ICallableModule interfaces.
Public interface IIndex Represents a SQL Server index.
Public interface IIndexedColumn Represents a SQL Server column that is participating in an index.
Public interface ILocalVariable Defines a local variable or parameter.
Public interface ILogin Represents a SQL Server login.
Public interface IMetadataCollection<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.
Public interface IMetadataObject Represents a SQL Server metadata object.
Public interface IMetadataObjectVisitor<T> Represents a SQL Server metadata object visitor.
Public interface IMetadataOrderedCollection<T> Represents a collection of metadata objects where the element ordering is preserved.
Public interface IMutableApplicationRole Represents a mutable SQL Server security role that enables an application to run with its own, user-like permissions.
Public interface IMutableAsymmetricKey Represents a mutable SQL Server asymmetric key.
Public interface IMutableCallableModule Represents a mutable SQL Server callable module, such as a stored procedure or a scalar-valued function.
Public interface IMutableCertificate Represents a mutable SQL Server certificate.
Public interface IMutableCheckConstraint Represents a mutable SQL Server CHECK constraint.
Public interface IMutableClrDataType Represents mutable user-defined CLR data type (UDT).
Public interface IMutableColumn Represents a mutable SQL Server column.
Public interface IMutableConstraint Represents tabular object mutable constraints.
Public interface IMutableCredential Represents a mutable SQL Server credential.
Public interface IMutableDatabase Represents a mutable SQL Server database. 
Public interface IMutableDatabaseDdlTrigger Represents a mutable database DDL trigger.
Public interface IMutableDatabaseObject Defines methods and properties that are common to all mutable database objects.
Public interface IMutableDatabaseOwnedObject Represents a mutable metadata object that is owned by an IDatabase object.
Public interface IMutableDatabasePermission Represents a mutable SQL Server database permission.
Public interface IMutableDatabasePrincipal Represents a mutable SQL Server database-level principal object.
Public interface IMutableDatabaseRole Represents a mutable SQL Server database security role.
Public interface IMutableDatabaseTable Represents a database table.
Public interface IMutableDataType Represents a mutable SQL Server data type.
Public interface IMutableDefaultConstraint Represents a mutable SQL Server default constraint.
Public interface IMutableDmlTrigger Represents a mutable SQL Server DML trigger.
Public interface IMutableForeignKeyConstraint Represents a mutable SQL Server FOREIGN KEY constraint.
Public interface IMutableFunction Represents a mutable SQL Server function. 
Public interface IMutableFunctionModuleBase Common base interface for the IMutableFunction and IMutableCallableModule interfaces.
Public interface IMutableIndex Represents a mutable SQL Server index.
Public interface IMutableIndexedColumn Represents a mutable SQL Server column that is participating in an index.
Public interface IMutableLogin Represents a mutable SQL Server login.
Public interface IMutableMetadataCollection<T> Defines methods to manipulate collections of objects that implement the IMetadataObject interface.
Public interface IMutableMetadataObject Defines common interface of all mutable metadata objects.
Public interface IMutableMetadataOrderedCollection<T> Represents a mutable collection of metadata objects where the element ordering is preserved.
Public interface IMutablePassword Represents a mutable SQL Server login password.
Public interface IMutableRelationalIndex Represents a mutable SQL Server relational index.
Public interface IMutableScalar Represents a mutable scalar metadata object.
Public interface IMutableScalarDataType Represents a mutable SQL Server scalar data type.
Public interface IMutableScalarFunction Represents a mutable SQL Server scalar function.
Public interface IMutableScalarValuedFunction Represents a mutable SQL Server scalar-valued function.
Public interface IMutableSchema Represents a mutable SQL Server schema.
Public interface IMutableSchemaOwnedObject Represents a mutable metadata object that is owned by a schema.
Public interface IMutableServer Represents a mutable instance of SQL Server.
Public interface IMutableServerDdlTrigger Represents a mutable SQL Server DDL trigger.
Public interface IMutableServerOwnedObject Represents a mutable metadata object that is owned by an IServer object.
Public interface IMutableSpatialIndex Represents a SQL Server spatial index.
Public interface IMutableStatistics Represents a SQL Server statistics object.
Public interface IMutableStoredProcedure Represents a mutable SQL Server stored procedure.
Public interface IMutableSynonym Represents a mutable synonym.
Public interface IMutableTable Represents a mutable SQL Server database table.
Public interface IMutableTableDataType Represents a mutable SQL Server table data type.
Public interface IMutableTableValuedFunction Represents a mutable SQL Server table-valued function.
Public interface IMutableTableViewBase Base interface for the IMutableTable and IMutableView interfaces.
Public interface IMutableTabular Defines a mutable interface for tabular metadata objects.
Public interface IMutableTrigger Represents a mutable SQL Server trigger.
Public interface IMutableTriggerEventTypeSet Represents a set of mutable trigger events.
Public interface IMutableUser Represents a mutable SQL Server user.
Public interface IMutableUserDefinedClrType Represents a mutable SQL Server user-defined CLR type (UDT).
Public interface IMutableUserDefinedDataType Represents a mutable user-defined data type.
Public interface IMutableUserDefinedFunction Represents a mutable user-defined function.
Public interface IMutableUserDefinedFunctionModuleBase Common base interface for the IMutableUserDefinedFunction and IMutableCallableModule interfaces.
Public interface IMutableUserDefinedTableType Represents a mutable user-defined table type.
Public interface IMutableUserDefinedType 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.
Public interface IMutableView Represents a mutable SQL Server database view. 
Public interface IMutableVirtualTable Represents a mutable virtual table (a table that is not database-persisted).
Public interface IParameter Represents a SQL Server parameter.
Public interface IPartitionScheme Represents a SQL Server partition scheme.
Public interface IPassword Represents a SQL Server login password.
Public interface IPrimaryKeyConstraint Represents a SQL Server PRIMARY KEY constraint.
Public interface IRelationalIndex Represents a SQL Server relational index.
Public interface IResolvedExtendedStoredProcedureSynonym Represents a synonym resolved to an extended stored procedure.
Public interface IResolvedScalarValuedFunctionSynonym Represents a synonym resolved to a scalar valued function.
Public interface IResolvedStoredProcedureSynonym Represents a synonym resolved to a stored procedure.
Public interface IResolvedSynonym Represents a resolved synonym.
Public interface IResolvedTableSynonym Represents a synonym resolved to a table.
Public interface IResolvedTableValuedFunctionSynonym Represents a synonym resolved to a table valued function.
Public interface IResolvedUserDefinedAggregateSynonym Represents a synonym resolved to a user defined aggregate.
Public interface IResolvedViewSynonym Represents a synonym resolved to a view.
Public interface IScalar Represents a scalar metadata object.
Public interface IScalarDataType Represents a SQL Server scalar data type.
Public interface IScalarExpression 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.
Public interface IScalarFunction Represents a SQL Server scalar function.
Public interface IScalarParameter Represents a SQL Server scalar parameter.
Public interface IScalarValuedFunction Represents a SQL Server scalar-valued function.
Public interface IScalarVariable Represents a SQL Server scalar variable.
Public interface ISchema Represents a SQL Server schema.
Public interface ISchemaOwnedObject Represents a metadata database object that is owned by a schema.
Public interface ISchemaOwnedObjectVisitor<T> Represents a SQL Server schema-owned object visitor.
Public interface IServer Represents an instance of SQL Server.
Public interface IServerDdlTrigger Represents a SQL Server DDL trigger. 
Public interface IServerOwnedObject Represents a metadata object that is owned by an IServer object.
Public interface IServerOwnedObjectVisitor<T> Represents a server-owned object visitor.
Public interface ISpatialIndex Represents a SQL Server spatial index.
Public interface IStatistics Represents a SQL Server statistics object.
Public interface IStoredProcedure Represents a SQL Server stored procedure. 
Public interface ISynonym Represents a SQL Server synonym object.
Public interface ISystemClrDataType Represents a SQL Server system CLR data type.
Public interface ISystemDataType Represents a SQL Server built-in system data type.
Public interface ITable Represents a SQL Server database table.
Public interface ITableDataType Represents a SQL Server table data type.
Public interface ITableParameter Represents a parameter of table type.
Public interface ITableValuedFunction Represents a SQL Server table-valued function.
Public interface ITableVariable Represents a SQL Server table variable. 
Public interface ITableViewBase Base interface for the ITable and IView interfaces.
Public interface ITabular Defines a common interface for all tabular metadata objects.
Public interface ITrigger Represents a SQL Server trigger.
Public interface ITriggerEventTypeSet Represents a set of trigger events.
Public interface IUdtDataMember Represents a user-defined type property or field.
Public interface IUdtMember Defines a common interface for all user-defined type members.
Public interface IUdtMethod Represents a SQL Server user-defined type method.
Public interface IUniqueConstraint Represents a SQL Server UNIQUE constraint.
Public interface IUniqueConstraintBase Base interface for UNIQUE and PRIMARY KEY constraints.
Public interface IUser Represents a SQL Server user.
Public interface IUserDefinedAggregate Represents a SQL Server user-defined aggregate.
Public interface IUserDefinedClrType Represents a SQL Server user-defined CLR type (UDT).
Public interface IUserDefinedDataType Represents a user-defined data type.
Public interface IUserDefinedFunction Represents a user-defined function.
Public interface IUserDefinedFunctionModuleBase Common base interface for the IUserDefinedFunction and ICallableModule interfaces.
Public interface IUserDefinedTableType Represents a user-defined table type.
Public interface IUserDefinedType 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.
Public interface IView Represents a SQL Server database view. 
Public interface IVirtualTable Represents a virtual table (a table that is not database-persisted).
Public interface IVoidDataType Represents a void data type.
Public interface IXmlDataType Represents the SQL Server xml data type.
Public interface IXmlDataTypeMethod Represents a method that can be called on a scalar of the xml data type.
Public interface IXmlDataTypeTableMethod Represents a table valued method that can be called on a scalar of the xml data type.
Public interface IXmlIndex Represents a SQL Server XML index.

Enumerations

  Enumeration Description
Public enumeration ActivationOrder Specifies the relative activation order of a trigger.
Public enumeration CallableModuleType Defines the callable module types.
Public enumeration ConstraintType Specifies SQL Server constraint types.
Public enumeration DatabasePermissionType Specifies the SQL Server database permission types.
Public enumeration ExecutionContextType Specifies the execution context for the user-defined module.
Public enumeration ForeignKeyAction Specifies the action that is taken when the primary key that is referenced by a foreign key is updated.
Public enumeration GridDensity Specifies the grid density for a spatial index.
Public enumeration IndexType Indicates the type of the index.
Public enumeration LoginType Specifies the login type.
Public enumeration PermissionState Specifies SQL Server permission state.
Public enumeration ScalarType Defines the scalar object types.
Public enumeration SortOrder Defines the item sort order.
Public enumeration SqlDataType Specifies the SQL Server built-in data type.
Public enumeration StatisticsType Indicates the type of the statistics.
Public enumeration SynonymBaseType Contains constant values that specify the type of synonym.
Public enumeration TabularType Defines a tabular object type.
Public enumeration UserType Specifies the user type.