How to get Field Default Value and how identify Primary Key Column in SQL with ADO 
Author Message
 How to get Field Default Value and how identify Primary Key Column in SQL with ADO

I'm trying to get the Field Default Value and the Primary Key Columns in a SQL table using ADO.
But I couldn't find the way.

Any help?

--
Charlie
ooo0
 (    )
  \  (
    \_)



Tue, 07 Sep 2004 05:11:38 GMT  
 How to get Field Default Value and how identify Primary Key Column in SQL with ADO
Call the openSchema method of the ADO Connection Object for Column
information.

Try the OpenSchema GUI built into AdoAnywhere to see what information your
particular provider will give for your database. ( Trial
www.adoanywhere.com/cnet )

You may find something in ADOX too. AdoAnywhere exposes your ADOX properties
too so you should be able to see.

--
Michael Collier Bsc (Hons)

Interactive ADO Browser Trial  www.adoanywhere.com/cnet
Free ADO Browser (FAB)  www.adoanywhere.com/fab
Home Page www.adoanywhere.com

--


I'm trying to get the Field Default Value and the Primary Key Columns in a
SQL table using ADO.
But I couldn't find the way.

Any help?

--
Charlie
ooo0
 (    )
  \  (
    \_)



Tue, 07 Sep 2004 06:21:15 GMT  
 How to get Field Default Value and how identify Primary Key Column in SQL with ADO

Thank you.

--
Charlie
ooo0
 (    )
  \  (
    \_)

  Call the openSchema method of the ADO Connection Object for Column
  information.

  Try the OpenSchema GUI built into AdoAnywhere to see what information your
  particular provider will give for your database. ( Trial
  www.adoanywhere.com/cnet )

  You may find something in ADOX too. AdoAnywhere exposes your ADOX properties
  too so you should be able to see.

  --
  Michael Collier Bsc (Hons)

  Interactive ADO Browser Trial  www.adoanywhere.com/cnet
  Free ADO Browser (FAB)  www.adoanywhere.com/fab
  Home Page www.adoanywhere.com

  --



  I'm trying to get the Field Default Value and the Primary Key Columns in a
  SQL table using ADO.
  But I couldn't find the way.

  Any help?

  --
  Charlie
  ooo0
   (    )
    \  (
      \_)



Tue, 07 Sep 2004 07:56:35 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Getting the Column Name of the Primary Key Column

2. Joined Primary Key in Foxpro (Make 1 Primary Key from 2 fields)

3. SQL Server Primary Key Values

4. PRB: get value of auto-increment primary key from SQL Server 7

5. Write SQL Query for a multiple fields primary key

6. ADO how to determine if a access database field is a primary key field

7. getting default values from sql server table

8. getting default values for sql server table

9. Getting (Key Field) Value

10. Auto generate GUID for Primary Key columns...

11. multi-column primary key in mysql - VB - myODBC problem

12. Error in getting Primary Key Row

 

 
Powered by phpBB® Forum Software