March 13, 2009 at 2:29 am
Hi,
Is it possible to find a tool FREE of course, for to build a schema of database !
i explain, before when i was on school there are a few years we use dezign for database this tool can design a db and we can generate sql script for sql server, oracle, and so on ..
With this tool we can create easily foreign key relation ship and so on ..it was easy for beginner to create a schema with multiple table.
Do you know a tool free for realize the same things !?
Thanks
Christophe
March 13, 2009 at 3:12 am
Hello Christophe
If you are using SQL Server Management Studio it has a build in feature to create database diagrams. Sure, only for SQL Server.
I think this might be what you are searching for.
Greets
Flo
March 13, 2009 at 3:21 am
Hi florian,
where i can find this tool !
i use of course management studio in sql server 2005.
i have create a db name DB_COPROPRIO and now i must to create all table with all relation ship but as a newbie i prefer BEFORE to create a schema and after execute it for create all table !
Thanks for all your information
Christophe
March 13, 2009 at 4:28 am
Hi
* Create a new database
* Expand the database node within the Object Explorer
* Click on the "Database Diagrams" node
* You will either automatically be asked to create a new one or right click and select "New Database Diagram"
* A designer window opens where you can select one or more existing tables or just cluse it
* Right click on the white background and select either "Add table..." to add other existing tables or select "New table..." to create a new one
* Now you can link tables by drag and drop
Greets
Flo
March 13, 2009 at 4:56 am
all right !
that's exactly what i want !
thanks for your time !
Have a nice week end
Christophe
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply