VistaDB 5

Specifies the name of the schema to return.
GetSchema(String) Method
Returns schema information for the data source of this VistaDBConnection using the specified string for the schema name and the specified string array for the restriction values. Examples schema that may be requested are: RESERVEDWORDS - list of words reserved for usage by the engine COLUMNS - List of columns DATATYPES - Types in usage by the current engine VIEWS - Views in the current database FOREIGNKEYS - Lists of foreign keys in database Class VistaDBConnection
Public Overloads Overrides NotOverridable Function GetSchema( _
   ByVal collectionName As System.String _
) As System.Data.DataTable
Dim instance As VistaDBConnection
Dim collectionName As System.String
Dim value As System.Data.DataTable
value = instance.GetSchema(collectionName)
public override System.Data.DataTable GetSchema( 
   System.string collectionName
public function GetSchema( 
    collectionName: System.String
): System.Data.DataTable; override; 
public override function GetSchema( 
   collectionName : System.String
) : System.Data.DataTable;
public: System.Data.DataTable* GetSchema( 
   System.string* collectionName
) override 
System.Data.DataTable^ GetSchema( 
   System.String^ collectionName
) override 


Specifies the name of the schema to return.

Return Value

A DataTable that contains schema information.
<<code lang="C#">> using (VistaDBConnection cn = new VistaDBConnection("Data Source=|DataDirectory|Database1.vdb5;")) { cn.Open(); DataTable schema = cn.GetSchema("FOREIGNKEYS"); foreach (DataRow dr in schema.Rows) { foreach (DataColumn dc in schema.Columns) { Console.WriteLine(dc.ColumnName + " = " + dr[dc].ToString()); } } } <</code>>

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also