Sunday, February 12, 2012

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)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.

No comments:

Post a Comment