xSQL Schema Compare SDK version 9.5 for SQL Server
SqlTable Class Properties


For a list of all members of this type, see SqlTable members.

Public Properties
 NameDescription
Public PropertyChangeDataCapture Gets or sets the object that contains the change data capture settings for the table.  
Public PropertyDataCompression Gets or sets the data compression for the table.  
Public PropertyFileGroup Gets or sets the filegroup in which the table is created.  
Public PropertyFileStreamFileGroup Gets or sets the filestream filegroup for the table.  
Public PropertyFileStreamPartitionSchema Gets or sets the filestream partition scheme for the table.  
Public PropertyFullName 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)
Public PropertyFullNameDelimited Gets the delimited full name for the entity formatted as [schema].[name]. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyFullyQualifyingName Gets the fully-qualifying name for the entity. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyFullyQualifyingNameDelimited Gets the fully-qualifying name for the entity with delimiters. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertyHasEncryptedColumns Gets the value that indicates whether the table has encrypted columns.  
Public PropertyHasFileStream Gets the value that indicates whether the table is created with the filestream attribute.  
Public PropertyHasIdentity Gets or sets the value that indicates whether the table has an identity column.  
Public PropertyHasMaskedColumns Gets the value that indicates whether the table has columns that use dynamic masking.  
Public PropertyHasSystemTimeColumns Gets the value that indicates whether the table has system-time columns, which are the columns created with the "Generated Always" property.  
Public PropertyId Gets or sets a unique id for the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyIsAnsiNullsOn Gets or sets the value that indicates whether the ANSI_NULLS attribute is ON. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertyIsAnsiPaddingOn Gets or sets the value that indicates whether the ANSI_PADDING property is ON.  
Public PropertyIsChangeDataCaptureEnabled Gets or sets the value that indicates whether the change data capture is enabled for the table.  
Public PropertyIsChangeTrackingEnabled Gets or sets the value that indicates whether the change tracking is enabled for the table.  
Public PropertyIsChangeTrackingOnUpdatedColumnsEnabled Gets or sets the value that indicates whether the change tracking on updated columns is enabled.  
Public PropertyIsPartitioned Gets or sets the value that indicates whether the table is partitioned.  
Public PropertyIsQuotedIdentifierOn Gets or sets the value that indicates whether the QUOTED_IDENTIFIER attribute is ON. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertyIsReplicated Gets or sets the property that indicates whether the table is replicated via a snapshot, transactional or merge replication.  
Public PropertyIsSystemVersioned Gets the value that indicates whether the table is system-versioned.  
Public PropertyLockEscalation Gets or sets the lock escalation for the table.  
Public PropertyName Gets or sets the name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyParent Gets the parent entity of this entity. (Inherited from xSQL.Schema.Core.Entity)
Public PropertyPartitionColumn Gets or sets the partition column for the table.  
Public PropertyPartitionScheme Gets or sets the partition scheme for the table.  
Public PropertyReferencedSqlForeignKeys Gets the collection of foreign keys that reference this table.  
Public PropertyRemoteDataArchiving Gets or sets the object that contains information related to remote data archiving or table stretching.  
Public PropertySchema Gets or set the entity schema. (Inherited from xSQL.Schema.Core.Entity)
Public PropertySqlCheckConstraints Gets the collection of table-level check constraints. These are the constraints that reference more than one column.  
Public PropertySqlClrTriggers Gets the collection of CLR triggers. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlColumns Gets the collection of columns that belong to the table or view. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlDatabaseGets the SqlDatabase to which the entity belongs. (Inherited from xSQL.Schema.SqlServer.SqlEntity)
Public PropertySqlEntityType Gets the type of the entity. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public PropertySqlExtendedProperties Gets the collection of extended properties. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlForeignKeys Gets the collection of foreign keys that belong to the table.  
Public PropertySqlFullTextIndex Gets or sets the full-text index. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlIndexes Gets the collection of indexes. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlPermissions Gets the collection of permissions assigned to the table or view. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlPrimaryKey Gets or sets the primary key for the table.  
Public PropertySqlSpatialIndexes Gets the collection of spatial indexes that belong to the table.  
Public PropertySqlStatistics Gets the collection of statistics. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlTriggers Gets the collection of triggers. (Inherited from xSQL.Schema.SqlServer.TableViewBase)
Public PropertySqlUniqueConstraints Gets the collection of unique constraints that belong to the table.  
Public PropertySqlXmlIndexes Gets the collection of xml indexes that belong to the table.  
Public PropertySupportsDiagram Gets or sets the property that indicates whether the table is created to support SQL Server diagrams.  
Public PropertySystemVersioning Gets or sets the object that contains information related to system-versioning.  
Public PropertySystemVersioningType Gets or set the value that indicates whether the type of system-versioning enabled for the table.  
Public PropertyTextFileGroup Gets or sets the filegroup reserved for large value columns.  
Top
See Also

Reference

SqlTable Class
xSQL.Schema.SqlServer Namespace

 

 


┬ęCopyright 2018 xSQL Software. All Rights Reserved.

Send Feedback