Diagram Database.
-
HI all, within several days i will finish to develop a database with SqlServer 2005 ,this database is so big with a lot of tables and so on .Now i wish create a diagram(schema) for it that show all table with fields and respective datatype but i don't know how create it,i have not idea if i need a tool to create or else. I create a diagram with VisualStudio 2008 Sp1 but the diagram is without datatype, so do you have any idea how create e diagram (schema) of a database?Do i need a particular tool to create it? All advice will be useful and nice. Thanks. Nice Regards :)
-
HI all, within several days i will finish to develop a database with SqlServer 2005 ,this database is so big with a lot of tables and so on .Now i wish create a diagram(schema) for it that show all table with fields and respective datatype but i don't know how create it,i have not idea if i need a tool to create or else. I create a diagram with VisualStudio 2008 Sp1 but the diagram is without datatype, so do you have any idea how create e diagram (schema) of a database?Do i need a particular tool to create it? All advice will be useful and nice. Thanks. Nice Regards :)
-
HI all, within several days i will finish to develop a database with SqlServer 2005 ,this database is so big with a lot of tables and so on .Now i wish create a diagram(schema) for it that show all table with fields and respective datatype but i don't know how create it,i have not idea if i need a tool to create or else. I create a diagram with VisualStudio 2008 Sp1 but the diagram is without datatype, so do you have any idea how create e diagram (schema) of a database?Do i need a particular tool to create it? All advice will be useful and nice. Thanks. Nice Regards :)
-
Using VS, connnect to your DB, expand it, just above the tables there is an option of diagrams, right click it and choose new diagram, then add all your tables You an also do the same from sql server management studio
Alexei Rodriguez
Hi Mr.Alexei, thanks to reply me, i knew how make the diagram with VS but i don't know how make the diagram with Data Type or better i wish display in the Diagram for each field the kind of Data Type for example: COLUMN NAME__________________DATA TYPE - CustomerID___________________ int - Name_______________________nvarchar(20) - Address_____________________nvarchar(30) ....and so on. Is it possible to create this kind of Diagram? Thanks so much.
-
Hi Mr.Alexei, thanks to reply me, i knew how make the diagram with VS but i don't know how make the diagram with Data Type or better i wish display in the Diagram for each field the kind of Data Type for example: COLUMN NAME__________________DATA TYPE - CustomerID___________________ int - Name_______________________nvarchar(20) - Address_____________________nvarchar(30) ....and so on. Is it possible to create this kind of Diagram? Thanks so much.
-
Also, i cant beleive you just finished designing a big DB and you dont know how to create a diagram :p
Alexei Rodriguez
Next question will be "Why can't I save the diagram, I get a foriengn key violation" X| And then what is a clustered index.
Never underestimate the power of human stupidity RAH
-
HI all, within several days i will finish to develop a database with SqlServer 2005 ,this database is so big with a lot of tables and so on .Now i wish create a diagram(schema) for it that show all table with fields and respective datatype but i don't know how create it,i have not idea if i need a tool to create or else. I create a diagram with VisualStudio 2008 Sp1 but the diagram is without datatype, so do you have any idea how create e diagram (schema) of a database?Do i need a particular tool to create it? All advice will be useful and nice. Thanks. Nice Regards :)
A database diagram is the very foundation of a database design and development effort. It represents the basic structure of a database; how information is stored, categorized and managed within it. Creately supports all database models (i.e. relational model, hierarchical model, network model etc.), and the following database model templates are made with its Database design software Source:[
Database Model Templates
](https://creately.com/blog/examples/database-model-templates/)