creating tables with SQL - TechRepublic
General discussion
July 19, 2000 at 09:02 AM
joel m

creating tables with SQL

by joel m . Updated 25 years, 10 months ago

hello,
I’ve started learn ASP and making database driven web sites…I’ve gotten pretty proficient at it, but I want to start making tables dynamically using SQL.

I’ve found tons of resources on this, and SQL tutorials, but none of them tellme how to make the 2 data types that I need most (in this case).
-an autonumber field.
-a memo field

my questions are these:

1. what is the syntax to create a table that includes these data types.

2. are these data types proprietary to MSACCESS? (which would explain why I found no info on them)

thanks in advance,
Joel
jdm.4mg.com

This discussion is locked

All Comments