I know this technically isn't a LC question but I want to access with LC.
I am so wet behind the ears that I don't know how when creating a SQL database to define how many columns or their names.
25 years ago I did a lot of dBase II, III & IV work but I have never touched a SQL database from a programming point of view.
Can someone please point me to a step by step example of doing this?
Thanks for the help.
Tom
Create SQL db and naming columns
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Create SQL db and naming columns
Hi Tom,
http://www.w3schools.com/sql/sql_create_table.asp
that's where I started with SQL
Best
Klaus
http://www.w3schools.com/sql/sql_create_table.asp
that's where I started with SQL

Best
Klaus
Re: Create SQL db and naming columns
Hi Klaus,
That was FAST!!!
Thanks so much, that is exactly what I have been looking for.
Tom
That was FAST!!!
Thanks so much, that is exactly what I have been looking for.
Tom