free tool for to build a schema of database !?

  • 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

  • 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

  • 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

  • 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

  • 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