This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 13%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
I have been moving very slowly in SQL SMS to get some tables going for my PowerApps applications. Its been very slow going because I'm just not real deep into SQL scripting. I was hoping there was some kind of GUI out there that could handle all of that back-end for me, and I could use some nice menu-driven/visual kind of ways to create and modify some tables. Of course, I would love it to be free, because the need is really not very long, and I dont want to invest in something I will only use a few days.
Thank you!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
SSMS is free and does everything you describe. Are you having a problem with SSMS?
SSMS does include both a table designer and a query designer. Then again, both of them are really bad, and I advice against use of any of them.
SSDT which is a plugin to Visual Studio has a table designer which is better as recall.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @Rod Martin ,
You can use SSDT which is available and free in the visual studio to add or modify table as Erland mentioned. You can get SSDT in Visual Studio Installer,under Data storage and processing in the list of workloads. Please refer to Download SSDT for more details, And please refer to this article about creating and maintaining tables in SSDT which might help.
In addition, you can try some 3-rd party tools which might help:
https://www.devart.com/dbforge/sql/studio/database-diagram.html
https://www.heidisql.com
And you have any recommendation about SSMS, you can submit it to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server. Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.