xSQL.Schema.SqlServer Namespace : SqlDatabase Class |
The following tables list the members exposed by SqlDatabase.
Name | Description | |
---|---|---|
ConnectionString | Gets or sets the dedicated connection string for the database which contains the credentials required to connect to the database. By default the database use the credentials of the parent SQL Server. | |
DependencyManager | Provides access to database dependencies. | |
FullName | Gets the full name of the entity formatted as schema.name. If the entity has no schema, only the name is returned. (Inherited from xSQL.Schema.Core.Entity) | |
FullNameDelimited | Gets the delimited full name for the entity formatted as [schema].[name]. (Inherited from xSQL.Schema.SqlServer.SqlEntity) | |
FullyQualifyingName | Gets the fully-qualifying name for the entity. (Inherited from xSQL.Schema.SqlServer.SqlEntity) | |
FullyQualifyingNameDelimited | Gets the fully-qualifying name for the entity with delimiters. (Inherited from xSQL.Schema.SqlServer.SqlEntity) | |
Id | Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity) | |
IsLoadedFromSnapshot | Gets the value that indicates whether the database is loaded from a snapshot file. | |
Name | Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity) | |
Parent | Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity) | |
Properties | Gets the SqlDatabasePropertySet object that provides access to various database properties. | |
Schema | Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity) | |
Session | Provides access to the most-recent schema read session. See SchemaSession class for more details. | |
SqlAggregates | Gets the collection of user-defined aggregates. | |
SqlApplicationRoles | Gets the collection of database application roles. | |
SqlAssemblies | Gets the collection of database .NET assemblies. | |
SqlAsymmetricKeys | Gets the collection of database asymmetric keys. | |
SqlBrokerContracts | Gets the collection of Service Broker contracts. | |
SqlBrokerMessageTypes | Gets the collection of Service Broker message types. | |
SqlBrokerPriorities | Gets the collection of Service Broker priorities. | |
SqlBrokerQueues | Gets the collection of Service Broker queues. | |
SqlBrokerRemoteServiceBindings | Gets the collection of Service Broker remote service bindings. | |
SqlBrokerRoutes | Gets the collection of Service Broker routes. | |
SqlBrokerServices | Gets the collection of Service Broker services. | |
SqlCertificates | Gets the collection of database certificates. | |
SqlClrDatabaseTriggers | Gets the collection of database CLR triggers. | |
SqlClrDataTypes | Gets the collection of CLR (user-defined) types. | |
SqlClrFunctions | Gets the collection of CLR functions. | |
SqlClrProcedures | Gets the collection of CLR procedures. | |
SqlColumnEncryptionKeys | Gets the collection of the column encryption keys in the database. | |
SqlColumnMasterKeys | Gets the collection of the column master keys in the database. | |
SqlDatabase | Gets the SqlEntity.SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity) | |
SqlDatabaseRoles | Gets the collection of database roles. | |
SqlDatabaseTriggers | Gets the collection of database triggers. | |
SqlDefaults | Gets the collection of defaults. | |
SqlEntityType | Gets the type of the entity. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) | |
SqlExtendedProperties | Gets the collection of extended properties for the database. | |
SqlFileGroups | Gets the collection of database filegroups. | |
SqlFullTextCatalogs | Gets the collection of full-text catalogs. | |
SqlFullTextStopLists | Gets the collection of full-text stop lists. | |
SqlFunctions | Gets the collection of user-defined functions. | |
SqlLogFiles | Gets the collection database log files. | |
SqlMemoryTables | Gets the collection of memory-optimized tables. | |
SqlPartitionFunctions | Gets the collection of partition functions. | |
SqlPartitionSchemes | Gets the collection of partition schemes. | |
SqlPermissions | Gets the collection of database permissions including statement permissions. | |
SqlProcedures | Gets the collection of user-defined stored procedures. | |
SqlRules | Gets the collection of rules. | |
SqlSchemas | Gets the collection of database schemas. | |
SqlSearchPropertyLists | Gets the collection of search property lists. | |
SqlSecurityPolicies | Gets the collection of the security policies in the database. | |
SqlSequences | Gets the collection of sequences. | |
SqlServer | Gets the SqlServer on which the database resides. | |
SqlSymmetricKeys | Gets the collection of database symmetric keys. | |
SqlSynonyms | Gets the collection of synonyms. | |
SqlTables | Gets the collection of database tables. | |
SqlUserDefinedDataTypes | Gets the collection of user-defined data types. | |
SqlUserDefinedTableTypes | Gets the collection of user-defined table types. | |
SqlUsers | Gets the collection of database users. | |
SqlViews | Gets the collection of database views. | |
SqlXmlSchemaCollections | Gets the collection of database xml schema collections. |
Name | Description | |
---|---|---|
CreateFromSnapshot | Overloaded. Creates a database objects from the specified snapshot. | |
CreateScripter | Gets a xSQL.Schema.SqlServer.SqlScripter object that can be used to generate T-SQL script for the database objects. | |
Equals | Overloaded. Returns true if this instance of the SqlScriptableEntity class is equal to the other object, which should also be an instance of SqlScriptableEntity class. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) | |
GetConnectionString | Gets the connection string for the database, which contains the credentials required to connect to the database. | |
GetDefaultSnapshotFilename | Returns the default filename for the database snapshot. | |
GetScript | Returns the T-SQL script for this entity with the specified scripting options. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) | |
ReadSchema | Overloaded. Reads the database schema. | |
SaveToSnapshot | Overloaded. Saves the schema of the database to a snapshot file with the specified name. | |
ToString | Returns the full name of the entity. (Inherited from xSQL.Schema.Core.Entity) |
Name | Description | |
---|---|---|
SchemaOperation | A generic event that provides information during schema operations. | |
SchemaOperationCanceled | The event that occurs after a schema operation is canceled. | |
SnapshotOperation | An event that provides progress information during the creation of a database snapshot. | |
SqlAggregateFinished | The event that indicates that the schema read of user-defined aggregates has finished. | |
SqlApplicationRoleFinished | The event that indicates that the schema read of application roles has finished. | |
SqlAssemblyFileFinished | The event that indicates that the schema read of assembly files has finished. | |
SqlAssemblyFinished | The event that indicates that the schema read of database .NET assemblies has finished. | |
SqlAsymmetricKeyFinished | The event that indicates that the schema read of asymmetric keys has finished. | |
SqlBrokerContractFinished | The event that indicates that the schema read of service broker contracts has finished. | |
SqlBrokerMessageTypeFinished | The event that indicates that the schema read of service broker message types has finished. | |
SqlBrokerPriorityFinished | The event that indicates that the schema read of service broker priorities has finished. | |
SqlBrokerQueueFinished | The event that indicates that the schema read of service broker queues has finished. | |
SqlBrokerRemoteServiceBindingFinished | The event that indicates that the schema read of service broker remote service bindings has finished. | |
SqlBrokerRouteFinished | The event that indicates that the schema read of service broker routes has finished. | |
SqlBrokerServiceFinished | The event that indicates that the schema read of broker services has finished. | |
SqlCertificateFinished | The event that indicates that the schema read of certificates has finished. | |
SqlCheckConstraintFinished | The event that indicates that the schema read of check constraints has finished. | |
SqlClrDataTypeFinished | The event that indicates that the schema read of CLR data types has finished. | |
SqlClrFunctionFinished | The event that indicates that the schema read of CLR functions has finished. | |
SqlClrProcedureFinished | The event that indicates that the schema read of CLR procedures has finished. | |
SqlClrTriggerFinished | The event that indicates that the schema read of CLR triggers has finished. | |
SqlColumnFinished | The event that indicates that the schema read of columns has finished. | |
SqlDatabaseClrTriggerFinished | The event that indicates that the schema read of database CLR triggers has finished. | |
SqlDatabaseRoleFinished | The event that indicates that the schema read of database roles has finished. | |
SqlDatabaseTriggerFinished | The event that indicates that the schema read of database triggers has finished. | |
SqlDefaultConstraintFinished | The event that indicates that the schema read of default constraints has finished. | |
SqlDefaultFinished | The event that indicates that the schema read of database defaults has finished. | |
SqlExtendedPropertyFinished | The event that indicates that the schema read of extended properties has finished. | |
SqlForeignKeyFinished | The event that indicates that the schema read of foreign keys has finished. | |
SqlFullTextCatalogFinished | The event that indicates that the schema read of full-text catalogs has finished. | |
SqlFullTextIndexFinished | The event that indicates that the schema read of full-text indexes has finished. | |
SqlFullTextStopListFinished | The event that indicates that the schema read of full-text stop lists has finished. | |
SqlFunctionFinished | The event that indicates that the schema read of user-defined functions has finished. | |
SqlIndexFinished | The event that indicates that the schema read of indexes has finished. | |
SqlMemoryTableFinished | The event that indicates that the schema read of memory-optimized tables has finished. | |
SqlPartitionFunctionFinished | The event that indicates that the schema read of partition functions has finished. | |
SqlPartitionSchemeFinished | The event that indicates that the schema read of partition schemes has finished. | |
SqlPermissionFinished | The event that indicates that the schema read of permissions has finished. | |
SqlPrimaryKeyFinished | The event that indicates that the schema read of primary keys has finished. | |
SqlProcedureFinished | The event that indicates that the schema read of stored-procedures has finished. | |
SqlRuleFinished | The event that indicates that the schema read of rules has finished. | |
SqlSchemaFinished | The event that indicates that the schema read of database schemas has finished. | |
SqlSearchPropertyFinished | The event that indicates that the schema read of search properties has finished. | |
SqlSearchPropertyListFinished | The event that indicates that the schema read of search property lists has finished. | |
SqlSecurityPolicyFinished | The event that indicates that the schema read of the security policies has finished. | |
SqlSequenceFinished | The event that indicates that the schema read of sequences has finished. | |
SqlSpatialIndexFinished | The event that indicates that the schema read of spatial indexes has finished. | |
SqlStatisticFinished | The event that indicates that the schema read of statistics has finished. | |
SqlSymmetricKeyFinished | The event that indicates that the schema read of symmetric keys has finished. | |
SqlSynonymFinished | The event that indicates that the schema read of synonyms has finished. | |
SqlTableFinished | The event that indicates that the schema read of database tables has finished. | |
SqlTriggerFinished | The event that indicates that the schema read of triggers has finished. | |
SqlUniqueConstraintFinished | The event that indicates that the schema read of unique constraints has finished. | |
SqlUserDefinedDataTypeFinished | The event that indicates that the schema read of user-defined data types has finished. | |
SqlUserDefinedTableTypeFinished | The event that indicates that the schema read of user-defined table types has finished. | |
SqlUserFinished | The event that indicates that the schema read of database users has finished. | |
SqlViewFinished | The event that indicates that the schema read of database views has finished. | |
SqlXmlIndexFinished | The event that indicates that the schema read of xml indexes has finished. | |
SqlXmlSchemaCollectionFinished | The event that indicates that the schema read of xml schema collections has finished. |