Setting up a SQL Database
20 February 2007, 03:39 PM
#1
Scooby Regular
Thread Starter
Join Date: Apr 2005
Location: Malta
Posts: 1,084
Likes: 0
Received 0 Likes
on
0 Posts
Setting up a SQL Database
I usually work with mdb, but I was planning on building a more secure and larger online database. So I guess SQL is the choice.
My question is, how do you create the tables and fields? Is it simple like opening Microsoft Access to crete the database or do I have to do it through a server?
My question is, how do you create the tables and fields? Is it simple like opening Microsoft Access to crete the database or do I have to do it through a server?
20 February 2007, 03:45 PM
#2
Scooby Regular
Join Date: Aug 2005
Posts: 4,290
Likes: 0
Received 0 Likes
on
0 Posts
i assume you mean sql server? sql is just a language to interrogate the database
you need to install sql server
and then use sql CREATE TABLE statements to... well do just that, create your tables.
you need to install sql server
and then use sql CREATE TABLE statements to... well do just that, create your tables.
20 February 2007, 04:47 PM
#3
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
If you use SQL Server you will use enterprise manager which is fairly similar to what you have seen in access to create tables which behind the scenes is issuing CREATE TABLE statements like Chef says. You can get hold of SQL Server 2005 express for free and management studio express which will do all you need.
Gary
Gary
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM