question

akc250 avatar image
akc250 asked

SQL Server Express shows code only

I'm new to SQL Server and any of the guides I search, whenever they create a new database or table, an actual explorer window or table with cells show up. However, (I'm using SQL Server Management Studio) when I try to create a table or database, it only creates a new tab with the code only. How do I view these user-friendly tables or design windows that automatically convert what I put into code?
sql-server-2014tablescreate-database
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Kryptos2015 avatar image
Kryptos2015 answered
You have to create a database diagram, there is an option if you extend your database on the left hand side, right click it and then create a new one, you will then be able to see the structure of your tables and the relationships between them, if you previously created them. You can also create relationships in there if you don't know how to code. However, I recommend you learn T-SQL, it's a lot quicker and easier to debug stuff than just using GUI.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.