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?
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.