Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 relational database

Author  Topic 

Mohamed Faisal
Yak Posting Veteran

51 Posts

Posted - 2012-09-19 : 05:19:07
Hi All,

I am new to SQL. Would like to ask how to I create 4 tables of a relational database. Do i have to create 4 database with one table. Or can i create 4 tables in one database. appreciate if you could recommend a website where i could refer to.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-09-19 : 05:34:52
First you create a database.

Second, you create the tables that you need in the database


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2012-09-20 : 00:00:33
Dear Mohamed,

As 'Khtan' is already suggested that first you should create a database after that you should create a table.

To enter data into the newly created Employees table, expand the Tables folder.

As you have already told that you are using SQL Server at first time then I will recommended you to read following starting guides: http://www.databasejournal.com/features/mssql/article.php/3759371/Create-Your-First-SQL-Server-Database-in-3-Quick-Steps.htm

Hope the article will help you to easily understand the basics of SQL Server Database!!!
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-20 : 01:43:32
You can also read some sections in SQL Server Books Online, Read on CREATE DATABASE and CREATE TABLE commands.
Follow up with reading on Definition Markup Language (DML) commands such as DELECT,INSERT , DELETE etc.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Mohamed Faisal
Yak Posting Veteran

51 Posts

Posted - 2012-09-23 : 07:32:02
HI All,

Thanks Allot. I did read some articles and now understand a bit....
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-24 : 01:50:53
your welcome

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -