xSQL Schema Compare SDK for SQL Server version 12
SqlTable Class Members
Properties  Methods 


The following tables list the members exposed by SqlTable.

Public Constructors
 NameDescription
Public ConstructorSqlTable ConstructorInitializes a new instance of the SqlTable class with the specified id, schema, name and database.  
Top
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 PropertyHasClusteredIndex Indicates whether the table has a clustered index, primary key or unique constraint.  
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 PropertyIsGraphEdge Gets or sets the value that indicates whether the table is an graph edge table.  
Public PropertyIsGraphNode Gets or sets the value that indicates whether the table is a graph node table.  
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 PropertyReferencedSqlEdgeConstraints Gets the collection of the edge constraints that reference this table. Only a node table can be referenced by the edge constraints.  
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 PropertySqlEdgeConstraints Gets the collection of the edge constraints defined on an graph table. Only an edge table can have edge constraints.  
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
Public Methods
 NameDescription
Public MethodEqualsOverloaded. 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)
Public MethodGetScript Returns the T-SQL script for this entity with the specified scripting options. (Inherited from xSQL.Schema.SqlServer.SqlScriptableEntity)
Public MethodToString Returns the full name of the entity. (Inherited from xSQL.Schema.Core.Entity)
Top
See Also

Reference

SqlTable Class
xSQL.Schema.SqlServer Namespace

 

 


©Copyright 2022 xSQL Software. All Rights Reserved.

Send Feedback