Off the top of my head, no, but what you can do is, if you have access to Enterprise Manager, create this exact table and then generate an SQL script, which will give you exactly what you need to duplicate the table in SQL Server.
-Andy > -----Original Message----- > From: Michael Lugassy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 1:55 PM > To: CF-Talk > Subject: Can anyone "Translate" this? > > > I have a mySQL CREATE script that I want to run on MS-SQL 2000. > Can anyone let me know how to "translate" this? > > CREATE TABLE content ( > catid mediumint(10) unsigned NOT NULL default '0', > link text, > link1 text, > link_count smallint(5) unsigned default NULL, > link_total int(6) unsigned default NULL, > symlinkfarm enum('Y','N') NOT NULL default 'N', > PRIMARY KEY (catid), > KEY link_total (link_total), > KEY symlinkfarm (symlinkfarm), > KEY link_count (link_count) > ) TYPE=MyISAM; > > Michael. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
