Difference Between Drop Table, Truncate Table & Delete Table in MS SQL Server – Zero to Hero Query Master – Part 6

Introduction In this article, we will discuss the difference between Drop Table, Truncate Table, Delete Table. To perform dropping, deleting and truncating a table, I am creating three tables. With these three tables let's look into more:  Students.StudentDetailsStudents.StudentMarks Students.StudentClass Drop TableThe syntax for dropping a table in MS SQL is,  Syntax DROP TABLE TableName Example DROP... Continue Reading →

Tables in Database- MS SQL Server – Zero to Hero Query Master – Part 5

Introduction All the data in a database is stored in a Table, which is a data object. Data is organized in Rows and Columns in a table and each row represents a unique record while each column represents a field in the record Types of Tables SQL Server provides the following types of tables that... Continue Reading →

Website Built with WordPress.com.

Up ↑

<span>%d</span> bloggers like this: