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 - 2001-02-18 : 21:52:03
|
Aruna Koya writes "I have a ACCESS table that includes the following two fields ID and AutoID. Only AutoID is an autonumber field. Other tables in the database have more than one field called similar ID names...
I need some SQL to test which field in each table is an autonumber field without using
ColumnName.Type="3"
or ColumnName.Name="ID"
Thanks in advance
Aruna" |
|
|
|
|
|
ACCESS Autonumber field test