<div>
Do this help ?<br />
<br />
<a href="http://www.blueclaw-db.com/alter_table_ddl.htm" rel="ugc">http://www.blueclaw-db.com/alter_table_ddl.htm</a>
</div>


Do this help ?

http://www.blueclaw-db.com/alter_table_ddl.htm [http://www.blueclaw-db.com/alter_table_ddl.htm]

<div>
Unfortunately not.. this is only describing how to do the ALTER command (which I already know)
</div>


Unfortunately not.. this is only describing how to do the ALTER command (which I already know)

<div>
You can use a thrid party tool :<br />
<br />
<a href="http://www.razorsql.com/docs/access_alter_table.html" rel="ugc">http://www.razorsql.com/docs/access_alter_table.html</a>
</div>


You can use a thrid party tool :

http://www.razorsql.com/docs/access_alter_table.html [http://www.razorsql.com/docs/access_alter_table.html]

<div>
Thanks for the advises - is ADOX part of the standard .NET lib? I could not find it..
</div>


Thanks for the advises - is ADOX part of the standard .NET lib? I could not find it..

<div>
No direct solution provided. However found alternative workaround to issue by setting a db schema version in the db
</div>


No direct solution provided. However found alternative workaround to issue by setting a db schema version in the db

<div>
<div class="content wysiwyg-content">
Is there some way to find out what type a field in a table is using SQL?<br />
<br />
I have a table with a DOUBLE field. In code I then want to run an ALTER table and change it to INTEGER if it is DOUBLE.
</div>
</div>


Is there some way to find out what type a field in a table is using SQL?

I have a table with a DOUBLE field. In code I then want to run an ALTER table and change it to INTEGER if it is DOUBLE.

MS ACCESS find out field type using SQL

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.