VistaDB 5
Properties  Methods 

VistaDB.DDA Namespace : IVistaDBTableSchema Interface
IVistaDBTableSchema Interface Members

The following tables list the members exposed by IVistaDBTableSchema.

Public Properties
 NameDescription
 PropertyNumber of columns in the table  
 PropertyCollection of constraints for this table (without foreign keys)  
 PropertyCollection of column default values information. These are the default value scripts defined for a column.  
 PropertyTable description  
 PropertyThe collection of names the dropped columns in the origin table schema  
 PropertyInformation about relationships for this table through the foreign keys constraints  
 PropertyCollection of identity information objects for this table  
 PropertyCollection of index information objects for this table  
 PropertyGets if the table is participating within synchronization services. The table cannot be altered or deleted while it is enrolled with a sync service provider.  
 PropertyThe table is used by VistaDB engine core as a system resource. The table cannot be deleted or altered while it is marked as a system resource.  
 PropertyThis table is collection of deleted rows used by database synchronization services. There is no need to manually manipulate this table, it is handled automatically by the VistaDB Engine. The table cannot be altered or deleted manually while marked to be participating in sync services.  
 PropertyOverloaded. Attributes of the table's column with specified name  
 PropertyName of the Table this schema was loaded from on disk.  
 PropertyThe collection of names the renamed columns in the origin table schema  
 PropertyCollection of CLR triggers assigned to this table  
Top
Public Methods
 NameDescription
 MethodOverloaded. Append new non-character type column  
 MethodAlter the name of a column  
 MethodDefines the new zero based column order for the column by its name in existing table schema. The other columns will be re-ordered in the table schema respectively.  
 MethodOverloaded. Alter the type of existing column  
 MethodOverloaded. Define column's attributes.  
 MethodSet constraint to check after insert, update or before delete operations.  
 MethodAssign default value to the column.  
 MethodAssign the identity to the column.  
 MethodDefine new index entry in table schema or update the existing one  
 Method (Inherited from System.IDisposable)
 MethodDrop the column by its name  
 MethodDrop an existing constraint.  
 MethodDrop the default value assigned to the column  
 MethodDrop existing identity  
 MethodDrop existing index from the table schema.  
 Method (Inherited from System.Collections.Generic.IEnumerable<IVistaDBColumnAttributes>)
Top
See Also