Hi

I am a beginner and produced the following basic design of three tables in MySQL.

What I would like to do is simply to convert this design from MySQL to MS SQL using the appropriate relevant types. Can someone please suggest them for me please?

Any ideas?

Thanks.

Mak.

-------
PHP Code:

mysql
describe articles;
+----------------+--------------+------+-----+------------+----------------+
Field          Type         Null Key | Default    | Extra          |
+----------------+--------------+------+-----+------------+----------------+
articleID      int(11)      |      | PRI NULL       auto_increment |
relAuthorID    int(11)      |      |     | 0          |                |
relTopicID     int(11)      |      |     | 0          |                |
articleTitle   varchar(200) |      |     |            |                |
articleDate    date         |      |     | 0000-00-00 |                |
articleContent longtext     YES  |     | NULL       |                |
+----------------+--------------+------+-----+------------+----------------+
6 rows in set (0.02 sec)[list]

mysqldescribe authors;
+-------------+-------------+------+-----+------------+----------------+
Field       Type        Null Key | Default    | Extra          |
+-------------+-------------+------+-----+------------+----------------+
authorID    int(11)     |      | PRI NULL       auto_increment |
authorFname varchar(50) | YES  |     | NULL       |                |
authorSname varchar(50) | YES  |     | NULL       |                |
authorEmail varchar(50) | YES  |     | NULL       |                |
authorDate  date        |      |     | 0000-00-00 |                |
+-------------+-------------+------+-----+------------+----------------+
5 rows in set (0.00 sec)

mysqldescribe topics;
+------------+--------------+------+-----+---------+----------------+
Field      Type         Null Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
topicID    int(11)      |      | PRI NULL    auto_increment |
topicTitle varchar(200) | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+
2 rows in set (0.00 sec
-------