Tony, Yes this is doable on msSql.
ALTER TABLE table ALTER COLUMN column_name int Be aware that the column type must be implicitely convertable. If you move from bigint to int and you have values too large for the type you will lose data. There are lots of nuances to doing this and they are outlined pretty well in SQL books online under "alter table". -Mark -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 1:39 PM To: CF-Talk Subject: sql help, easy one If I wanted to change the datatype of a column that is BigInt and change it to int is this possible with an alter table query? thanks/ tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
