Tables in SQL Server with Examples

In sql, the database will contain an one or more objects called tables and the tables are used to store a data or information related to particular application in database.

 

Generally, sql table is a compromise of multiple rows & columns and each table uniquely identified by its name. The columns in table will be defined with datatype and other properties but rows in table is used to store a data for columns. In sql database, our table’s structure will be like as shown below.

 

Newly created employeedetails table in sql server

In sql tables are used to perform a multiple data transactions like insert, update, delete, select, etc. based on requirements. For more information please check below list of actions which we can perform on sql data table.

 

  • SQL Create Table
  • SQL Insert into Table
  • SQL SELECT FROM TABLE
  • SQL Update Table
  • SQL Delete from Table
  • SQL TRUNCATE TABLE
  • SQL Drop Table

We will learn all these sections in next chapters of our sql tutorial.

 

PREVIOUS

SQL Any Operator