June 16, 2010 at 8:30 am
how to: generate the layout of some tables using visio 2007 professional?
Thank you.
June 16, 2010 at 8:36 am
Start a new Database Model Diagram in Visio. Then from the database menu select Reverse Engineer.
A wizard will lauch and you can follow the steps.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 16, 2010 at 9:04 am
What is a table layot?
Table layout is the desing of the table, correct?
design of the table is the name of the fields.
Is this it?
June 16, 2010 at 10:03 am
I apologize if there is a question there I am not getting it. Is the result of the reverse egineer wizard not what you expected? If that is the case what level of detail are you looking for?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 16, 2010 at 10:12 am
No, that's not the problem.
First, a company asked me for the layout of the tables of my database and i want to be choore that when they say "layout" (in database language) they mean the table name and the name of the fileds of each table inside my database, as Visio Displays this information throgh the reverse eng.
Second, Visio is not very good in terms of presenting this information, because when you add all the tables to your diagram they do not feet in one page...
there are other apps that present tables in a way that all the tables are below the other so they can feet in one page (in terms of scale), wich generates (when you print) several pages but each table is well feet inside is page.
June 16, 2010 at 10:17 am
If another company is asking for a table layout that it is likely they not only want to know what the fields are in the table but what the table data type definition is. If you are not talking about alot of tables then you coulde do this by generating a create script through ssms. you could then copy out the table definitions. it is likely that a vision diagram is not what they are looking for but then again they may not be thinking layout means the same as anyone. they may actually be looking for a great many things including constraints and keys. I think this is a case of asking them for clarification before you go much further.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply