 | |
RE: How to receive metadata about indices
Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet
 |
| | Thread Tools | Search this Thread | Display Modes |
#1
 
| |||
| |||
|
RE: How to receive metadata about indices -
10-13-2003
, 01:23 AM
|
Content-Class: urn:content-classes:message From: "Robert" <holler (AT) ergo-soft (DOT) com Sender: "Robert" <holler (AT) ergo-soft (DOT) com Subject: How to receive metadata about indices Date: Sun, 12 Oct 2003 13:57:02 -0700 Lines: 10 Message-ID: <03b501c39103$62f94aa0$a301280a (AT) phx (DOT) gbl MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Newsreader: Microsoft CDO for Windows 2000 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 Thread-Index: AcORA2L5ftOkOfsdSKSNmNSuvQizSg== Newsgroups: microsoft.public.dotnet.framework.odbcnet Path: cpmsftngxa06.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:3156 NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163 X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet Hi, I am looking for an equivalent to IDataReader.GetSchemaTable() to receive meta info about all indices of a table. Is there a "black hole" in the framework ? thx for help Robert |
#2
| |||
| |||
|
|
-----Original Message----- Hi Robert, Based on my understanding, you need to get the index information of a connection. You can try to call the OleDbConnection.GetOleDbSchemaTable() Method, and use OleDbSchemaGuid.Indexes as the first parameter. However, this can only be used on a connection through OleDb, because not all data sources support indices. For more information, please refer to the following: http://msdn.microsoft.com/library/default.asp? url=/library/en-us/cpref/html/ frlrfsystemdataoledboledbconnectionclassgetoledbsc hematabl etopic.asp http://msdn.microsoft.com/library/default.asp? url=/library/en-us/cpref/html/ frlrfsystemdataoledboledbschemaguidclassindexestop ic.asp Does this answer your question? If anything is unclear, please feel free to reply to the post. Kevin Yu ======= "This posting is provided "AS IS" with no warranties, and confers no rights." -------------------- | Content-Class: urn:content-classes:message | From: "Robert" <holler (AT) ergo-soft (DOT) com | Sender: "Robert" <holler (AT) ergo-soft (DOT) com | Subject: How to receive metadata about indices | Date: Sun, 12 Oct 2003 13:57:02 -0700 | Lines: 10 | Message-ID: <03b501c39103$62f94aa0$a301280a (AT) phx (DOT) gbl | MIME-Version: 1.0 | Content-Type: text/plain; | charset="iso-8859-1" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 | Thread-Index: AcORA2L5ftOkOfsdSKSNmNSuvQizSg== | Newsgroups: microsoft.public.dotnet.framework.odbcnet | Path: cpmsftngxa06.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.odbcnet:3156 | NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163 | X-Tomcat-NG: microsoft.public.dotnet.framework.odbcnet | | Hi, | | I am looking for an equivalent to | IDataReader.GetSchemaTable() to receive meta info about | all indices of a table. | | Is there a "black hole" in the framework ? | | thx for help | Robert | . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | Search this Thread |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.