Интерфейс IStoredProcedure

Represents a SQL Server stored procedure. 

Пространство имен:  Microsoft.SqlServer.Management.SqlParser.Metadata
Сборка:  Microsoft.SqlServer.Management.SqlParser (в Microsoft.SqlServer.Management.SqlParser.dll)

Синтаксис

'Декларация
Public Interface IStoredProcedure _
    Inherits ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject,  _
    IFunctionModuleBase, IMetadataObject
'Применение
Dim instance As IStoredProcedure

public interface IStoredProcedure : ICallableModule, 
    IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

public interface class IStoredProcedure : ICallableModule, 
    IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

type IStoredProcedure =  
    interface
        interface ICallableModule
        interface IUserDefinedFunctionModuleBase
        interface ISchemaOwnedObject
        interface IDatabaseObject
        interface IFunctionModuleBase
        interface IMetadataObject
    end

public interface IStoredProcedure extends ICallableModule, IUserDefinedFunctionModuleBase, ISchemaOwnedObject, IDatabaseObject, IFunctionModuleBase, IMetadataObject

Тип IStoredProcedure обеспечивает доступ к следующим элементам.

Свойства

	Имя	Описание
	BodyText	Gets the Transact-SQL statements that define the module.
	ExecutionContext	Gets the IExecutionContext object that specifies the module execution context. (Производный от IUserDefinedFunctionModuleBase.)
	ForReplication	Gets a value that indicates whether the stored procedure is available for replication.
	IsEncrypted	Gets a value that indicates whether the module is encrypted. (Производный от IUserDefinedFunctionModuleBase.)
	IsQuotedIdentifierOn	Gets a Boolean value that indicates whether the quoted identifier option is on.
	IsRecompiled	Gets a value that indicates whether the stored procedure is recompiled before execution.
	IsSqlClr	Gets a value that indicates whether this is a CLR module.
	IsSystemObject	Gets a value that indicates whether this is a system object. (Производный от IDatabaseObject.)
	ModuleType	Gets the module type. (Производный от ICallableModule.)
	Name	Gets the name of the metadata object. (Производный от IMetadataObject.)
	Parameters	Gets a collection that contains the parameters that the function or module accepts. (Производный от IFunctionModuleBase.)
	Parent	Gets the IDatabaseObject object that is the parent of this object. (Производный от IDatabaseObject.)
	ReturnType	Gets the scalar data type of the module return value. (Производный от ICallableModule.)
	Schema	Gets the ISchema object that owns this object. (Производный от ISchemaOwnedObject.)
	Startup	Gets a value that specifies whether the stored procedure runs when the instance of SQL Server starts up.

В начало

Методы

	Имя	Описание
	Accept< (Of < <' (T> ) > > )(IDatabaseObjectVisitor< (Of < <' (T> ) > > ))	Accepts a visit from the specified IDatabaseObjectVisitor<(Of <(<'T>)>)> object. (Производный от IDatabaseObject.)
	Accept< (Of < <' (T> ) > > )(IMetadataObjectVisitor< (Of < <' (T> ) > > ))	Accepts a visit from the specified IMetadataObjectVisitor<(Of <(<'T>)>)> object. (Производный от IMetadataObject.)
	Accept< (Of < <' (T> ) > > )(ISchemaOwnedObjectVisitor< (Of < <' (T> ) > > ))	Accepts a visit from the specified ISchemaOwnedObjectVisitor<(Of <(<'T>)>)> object. (Производный от ISchemaOwnedObject.)

В начало

См. также

Справочник

Пространство имен Microsoft.SqlServer.Management.SqlParser.Metadata