View Full Version : Changing ordinal position and datatype

02-02-2005, 05:36 AM
Does anyone know how to change the ordinal number of a field and the field datatype in Access using ASP?


02-03-2005, 05:26 PM
Alter keyword is used to change the properties of your database

Try this (http://www.w3schools.com/sql/sql_alter.asp) link... its from w3schools.com. You should search that site sometimes before you post.... it has alot of stuff and info there!

I also did a little search for you and here are some tutorials... I had a similar concern recently... hope these links help! :) :thumbsup:

This link (http://www.ilook.fsnet.co.uk/ora_sql/sqlhlp22.htm) directly discusses the ALTER keyword.

This, I think is another useful tutorial... http://sqlzoo.net/howto/source/s.pl.htm?index=i02create.xml&e=sqlserver

And the last link, a tutorial from plus2net (http://www.plus2net.com/sql_tutorial/sql_introduction.php).

Hope these helped you out!!! :thumbsup:

02-04-2005, 02:13 PM
Great tutorials! Thank you.

02-04-2005, 06:25 PM
u r welcome man!!!! :thumbsup: