Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-26 : 20:06:02
|
Joan writes "Hi!
Well, I'm trying to determine if a column is an autoincrement field using the ADO Schemas.
Seems not to be easy to acces Column Properties object, neither thru OpenSchema() method. I'm stuck here. The last chance was to use SS_DATA_TYPE column returned by OpenSchema(adColumn...) but I don't know what the values return mean.
A sample code was seeked and not found. I seek into MSDN Library (last version, 3 CD), in Microsoft, in learnasp.com, in several ASP lists anywhere, Wrox books .... the results are equal to zero. Can you help me?
In brief:
- I want to read the full schema from a SQL Server, and, among other questions and data, check the column property, Autoincrement. Is there any way to do it? In my efforts, Colum.Properties.Count returns 0.... I'm using NT4 + SQL7
Thanks from Spain!!!" |
|
|
|
|
|
Determining if a column is autoincrement thru ADO schemas