|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
April 16th, 2004, 04:43 AM
|
|||
|
|||
SQL Query wizard
Hi guys i am new to SQL world . Is there a software that can help the user to create database, make query visualy and also
it give you an option to get the corect sql statement for each query we make using visual wizards.
|
|
#2
April 16th, 2004, 07:19 AM
|
||||
|
||||
|
Depends on what type of database you're using. Mysqlfront and mysqlcc are pretty good, as is phpmyadmin (for mysql). DBDesigner is pretty good too, for that matter. If you're using MS SQL server, Enterprise Manager and Query Analyzer are the tools for you. For postgres, I believe there's a tool comparable to phpmyadmin.
__________________
Please don't PM me asking for solutions outside the scope of a thread. Keeping all responses in a thread stands to help others who come along later, which is after all what this forum's all about.
|
|
#3
April 20th, 2004, 05:17 AM
|
|||
|
|||
Well i thank you for your reply. Is there a software that can draw the reletions ship of tables with in any database
with a few simple click. I mean if we already have a DB and we need to draw it reletionship (MS access server db).?
|
|
#4
April 20th, 2004, 07:51 AM
|
||||
|
||||
|
In MS Access, go to Tools -> Relationships
In SQLServer, click on the diagrams node. Or you could just read the documentation 
|
|
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > SQL Query wizard |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
