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

Reply via email to