Constraints in SQL | Truncate & Drop Commands in SQL | Not Null,Check,Unique Constraints in SQL 2023
" Constraints in SQL | Truncate & Drop Commands in SQL | Not Null,Check,Unique Constraints in SQL Server | DBMS | SQL Tutorial
#constraintsinsql #parnikatutorials #sql
#Truncate #DropCommands #Constraints #NotNull #Check #UniqueConstraints #sqlserver #dbms #SQLTutorial #LearnOracleSQL #BasictutorialonOracleSQL #OracleSQLforbeginners #learnsql #oraclesql2023 #Deleteinsql #Differencebetweendeleteandtruncateinsql #Deletevstruncateinsql #Deletevstruncatevsdropinsql #Sqlbasics #Sqldeletevstruncatevsdrop
#SQL #MSSQL #MSSQLTraining #SQLTraining #SQLServerTutorials #SQLServerCourse #sqltrainingvideos #sqlservertraining #sqlservertutorialvideos #SQLServer
01:09 - truncating tables
01:20 - truncate statement
01:53 - syntax for truncate
02:55 - truncate table
03:34 - drop table statement
08:23 - types of constraints
09:06 - primary key constraints
11:02 - creating a table with called not null
12:33 - create a new table
14:02 - insert the data into the table
14:05 - using the insert statement"
In this video, I have discussed about Truncate Statement, Drop Statement, and Constraints in SQL
In Oracle, TRUNCATE TABLE statement is used to remove all records from a table. It works same as DELETE statement but without specifying a WHERE clause. It is generally used when you don?t have to worry about rolling back
Once a table is truncated, it can?t be rolled back. The TRUNCATE TABLE statement does not affect any of the table?s indexes, triggers or dependencies.
TRUNCATE TABLE [schema_name.]table_name;
Parameters
1) schema_name: This parameter specifies the name of the schema that the table belongs to. It is optional.
2) table_name: It specifies the table that you want to truncate.
DELETE TABLE customers;
Both the statements will remove the data from the "customers" table but the main difference is that you can roll back the DELETE statement whereas you can't roll back the TRUNCATE TABLE statement.
Constraints are the rules enforced on the data columns of a table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the database.
Constraints could be either on a column level or a table level. The column level constraints are applied only to one column, whereas the table level constraints are applied to the whole table.
NOT NULL Constraint − Ensures that a column cannot have NULL value.
UNIQUE Constraint − Ensures that all values in a column are different.
PRIMARY Key − Uniquely identifies each row/record in a database table.
FOREIGN Key − Uniquely identifies a row/record in any of the given database table.
CHECK Constraint − The CHECK constraint ensures that all the values in a column satisfies certain conditions.
Social media Links:
Instagram: / parnikatutorials
Website: http://parnikatutorials.in/
Email id: [email protected]
To get the regular updates:
Telegram link: https://t.me/Parnikatutorials
Facebook: https://m.facebook.com/profile.php?id...
Linkedin: / parnika-tutorials-a8a9831b2
Pinterest: / parnikatutorials0892
Playlists:
Virtual Coffee with Jagadeesh:
• VIRTUAL COFFEE WITH JAGADEESH
Digital Logic Design:
• Digital Logic Design
Computer Organization and Architecture:
• ABOUT PARNIKA TUTORIALS
C Programming:
• L 1: WHAT IS AN ALGORITHM AND CHARACT...
Data Structures:
• L 1: Uncover the Benefits of Linked L...
Theory of Computation:
• ABOUT PARNIKA TUTORIALS
Compiler Design:
• ABOUT PARNIKA TUTORIALS
Operating Systems: • PROCESS STATE DIAGRAM | LONG TERM, SH...
Databases: • ABOUT PARNIKA TUTORIALS
