xSQL Schema Compare SDK for SQL Server version 12
SqlTable Class Members
| xSQL.Schema.SqlServer Namespace : SqlTable Class |
The following tables list the members exposed by SqlTable.
| Name | Description | |
|---|---|---|
 | SqlTable Constructor | Initializes a new instance of the SqlTable class with the specified id, schema, name and database. |
| Name | Description | |
|---|---|---|
 | ChangeDataCapture | Gets or sets the object that contains the change data capture settings for the table. |
| DataCompression | Gets or sets the data compression for the table. |
| FileGroup | Gets or sets the filegroup in which the table is created. |
| FileStreamFileGroup | Gets or sets the filestream filegroup for the table. |
| FileStreamPartitionSchema | Gets or sets the filestream partition scheme for the table. |
| 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) |
| HasClusteredIndex | Indicates whether the table has a clustered index, primary key or unique constraint. |
| HasEncryptedColumns | Gets the value that indicates whether the table has encrypted columns. |
| HasFileStream | Gets the value that indicates whether the table is created with the filestream attribute. |
| HasIdentity | Gets or sets the value that indicates whether the table has an identity column. |
| HasMaskedColumns | Gets the value that indicates whether the table has columns that use dynamic masking. |
| HasSystemTimeColumns | Gets the value that indicates whether the table has system-time columns, which are the columns created with the "Generated Always" property. |
| Id | Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity) |
| IsAnsiNullsOn | Gets or sets the value that indicates whether the ANSI_NULLS attribute is ON. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| IsAnsiPaddingOn | Gets or sets the value that indicates whether the ANSI_PADDING property is ON. |
| IsChangeDataCaptureEnabled | Gets or sets the value that indicates whether the change data capture is enabled for the table. |
| IsChangeTrackingEnabled | Gets or sets the value that indicates whether the change tracking is enabled for the table. |
| IsChangeTrackingOnUpdatedColumnsEnabled | Gets or sets the value that indicates whether the change tracking on updated columns is enabled. |
| IsGraphEdge | Gets or sets the value that indicates whether the table is an graph edge table. |
| IsGraphNode | Gets or sets the value that indicates whether the table is a graph node table. |
| IsPartitioned | Gets or sets the value that indicates whether the table is partitioned. |
| IsQuotedIdentifierOn | Gets or sets the value that indicates whether the QUOTED_IDENTIFIER attribute is ON. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| IsReplicated | Gets or sets the property that indicates whether the table is replicated via a snapshot, transactional or merge replication. |
| IsSystemVersioned | Gets the value that indicates whether the table is system-versioned. |
| LockEscalation | Gets or sets the lock escalation for the table. |
| 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) |
| PartitionColumn | Gets or sets the partition column for the table. |
| PartitionScheme | Gets or sets the partition scheme for the table. |
| ReferencedSqlEdgeConstraints | Gets the collection of the edge constraints that reference this table. Only a node table can be referenced by the edge constraints. |
| ReferencedSqlForeignKeys | Gets the collection of foreign keys that reference this table. |
| RemoteDataArchiving | Gets or sets the object that contains information related to remote data archiving or table stretching. |
| Schema | Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity) |
| SqlCheckConstraints | Gets the collection of table-level check constraints. These are the constraints that reference more than one column. |
| SqlClrTriggers | Gets the collection of CLR triggers. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlColumns | Gets the collection of columns that belong to the table or view. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlDatabase | Gets the SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity) |
| SqlEdgeConstraints | Gets the collection of the edge constraints defined on an graph table. Only an edge table can have edge constraints. |
| SqlEntityType | Gets the type of the entity. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) |
| SqlExtendedProperties | Gets the collection of extended properties. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlForeignKeys | Gets the collection of foreign keys that belong to the table. |
| SqlFullTextIndex | Gets or sets the full-text index. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlIndexes | Gets the collection of indexes. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlPermissions | Gets the collection of permissions assigned to the table or view. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlPrimaryKey | Gets or sets the primary key for the table. |
| SqlSpatialIndexes | Gets the collection of spatial indexes that belong to the table. |
| SqlStatistics | Gets the collection of statistics. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlTriggers | Gets the collection of triggers. (Inherited from xSQL.Schema.SqlServer.TableViewBase) |
| SqlUniqueConstraints | Gets the collection of unique constraints that belong to the table. |
| SqlXmlIndexes | Gets the collection of xml indexes that belong to the table. |
| SupportsDiagram | Gets or sets the property that indicates whether the table is created to support SQL Server diagrams. |
| SystemVersioning | Gets or sets the object that contains information related to system-versioning. |
| SystemVersioningType | Gets or set the value that indicates whether the type of system-versioning enabled for the table. |
| TextFileGroup | Gets or sets the filegroup reserved for large value columns. |
| Name | Description | |
|---|---|---|
 | 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) |
| GetScript | Returns the T-SQL script for this entity with the specified scripting options. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity) |
| ToString | Returns the full name of the entity. (Inherited from xSQL.Schema.Core.Entity) |