TABLE DESIGNER METHOD IN SQL AND REVISION ON JOIN

TO CREATE TABLE USING DESIGNER METHOD

To create a table using the “Table Designer”, we’ll right-click on “Tables” under the database name and select “New Table…”. A new window will open, where we can specify the columns and data types. Once we’ve added all the columns, we’ll right click the top to save the visual representation of the table.

From there, we can add data by clicking on the “Design” tab and selecting “Edit Top 200 Rows”. We’ll then be able to edit the rows.

UPDATING THE TABLE

let’s talk about updating a table using the “Table Designer”. To update a table, we’ll right-click on the table in the “Object Explorer” and select “Edit Top 200 Rows”. This will open the table in “Edit” mode, where we can edit the rows. We can also right-click on a row to insert, delete, or copy it.

TO DELECT ITEM FROM TABLE

Highlight the row you want to delect and then right click and select delect to delect the entire row.

REVISION ON JOIN

Inner Join

Left outer Join

Right outer Join

Full Join