แชร์ผ่าน

  • บทความ

Microsoft.SqlServer.Management.SqlParser.Metadata Namespace

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.

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 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 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 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 IMutableStoredProcedure Represents a mutable SQL Server stored procedure.
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 IMutableTriggerEventSet<T> 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
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 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 IStoredProcedure Represents a SQL Server stored procedure. 
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 ITriggerEventSet<T> 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 IXmlIndex Represents a SQL Server XML index.

Enumerations

  Enumeration Description
Public enumeration CallableModuleType Defines the callable module types.
Public enumeration ConstraintType Specifies SQL Server constraint types.
Public enumeration DatabaseDdlTriggerEventType Represents a database DDL trigger event type.
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 LoginType Specifies the login type.
Public enumeration ScalarType Defines the scalar object types.
Public enumeration ServerDdlTriggerEventType Specifies the DDL events that can fire a DDL trigger.
Public enumeration SortOrder Defines the item sort order.
Public enumeration SqlDataType Specifies the SQL Server built-in data type.
Public enumeration TabularType Defines a tabular object type.
Public enumeration UserType Specifies the user type.