1. Use the Management Studio to create a new database called xxxWebDB using the

Question

1.     Use the Management Studio to create a new database called xxxWebDB using the default settings. (If the database already exists, use the Management Studio to delete it and then recreate it.)

Explanation / Answer

Open Management studio express, a connection window with SQL server will open. Enter Servername and Authentication of windows and click connect. After connected, click database folder, put DB name ( xxxWebDB ) and owner (default), click OK. Add tables, views, diagrams, etc.Here we ll add a table WebTable. Right Click on tables --> New table. New table data structure will open 3 parts: Table designer toolbar, spreadsheet for creating columns and column properties box. Insert fields in columns and set properties and datatype for each column. You can set Primary key also. To finish, just click on "X" in right side of table structure window. Save the table. Table will appear in the list of Tables folder.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.