SQL Server – Page 134

What Is SQL Server Management Studio (SSMS)?

December 18, 2020May 24, 2016 by Ian

SQL Server Management Studio (SSMS) is a graphical user interface (GUI) that can be used to administer SQL Server.

SQL Server Management Studio allows you to create and manage your databases as well as administer your SQL Server configuration.

February 14, 2020May 18, 2016 by Ian

To create a table in SQL Server using the GUI:

Ensuring that the right database is expanded in Object Explorer, right click on the Tables icon and select Table... from the contextual menu
A new table will open in Design view. Add the columns, their data types, and column properties.
Save the table (either from the File menu, or by right-clicking on the table tab and selecting Save Table1)

The table will appear in the Object Explorer under the Tables icon for the applicable database.

February 14, 2020May 18, 2016 by Ian

To create a database in SQL Server using the GUI:

From the Object Explorer, right click on Databases and select New database...
Name the database, adjust settings if required, then click OK

Once you’ve created the database, you can create tables and other database objects. You can also modify any database properties as required.