Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    UK
    Posts
    122

    Question Unanswered: A little help remembering how to do make table

    I can't remember how to add anew table but have written what I can if I may be so bold to ask for some help to create the table.

    This sql will be run in MS Access, MySQL and SQL Server if that makes a difference.

    Make TABLE [SysVar] fields [Key] text(15) restrant Key1 PrimaryKey, [value] text (25)
    Matt the Hat says: "what!?"
    A child of five could understand this! Fetch me a child of five!
    SCARY HARD CHALLENGE: http://www.dbforums.com/showthread.php?threadid=988682

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    This sql will be run in MS Access, MySQL and SQL Server if that makes a difference.

    It does. It won't run in SQL Server.

    Look up CREATE TABLE in Books Online for SQL Server.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •