Returns a DataTable containing column metadata for the supplied SQL statement/table name

Namespace:  DbNetLink.Data
Assembly:  DbNetLink.DbNetData (in DbNetLink.DbNetData.dll) Version: 1.0.0.0 (1.0.0.0)

Syntax

C#
public DataTable GetSchemaTable(
	string Sql
)
Visual Basic (Declaration)
Public Function GetSchemaTable ( _
	Sql As String _
) As DataTable
Visual C++
public:
DataTable^ GetSchemaTable(
	String^ Sql
)

Parameters

Sql
Type: System..::.String

SQL statement or table name

Return Value

A DataTable

Examples

CopyC#
DbNetData Db = new DbNetData( ConfigurationManager.ConnectionStrings["nwind"] );
Db.Open();
DataTable SchemaInfo = Db.GetSchemaTable("customers");
foreach ( DataRow R in     SchemaInfo.Rows )
    if (R["ColumnName"].ToString() == "CustomID" )
        if ( (bool)R["IsKey"]  )
            CustomerID.ReadOnly = true;

See Also