SQL TRUNCATE TABLE
SQL TRUNCATE TABLE statement is used to delete complete data from an existing table. It is similar to a delete statement without a WHERE clause.
1,089 total views
I am having a 7 + years of experience in microsoft technologies including Asp .NET, C# Power BI, SQL Server, SSRS, SSIS, Azure Fundamentals, & Python.
SQL TRUNCATE TABLE statement is used to delete complete data from an existing table. It is similar to a delete statement without a WHERE clause.
1,089 total views
A PRIMARY KEY constraint uniquely identifies each record in a table .
A COMPOSITE KEY is a combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness is guaranteed, but when it taken individually it does not guarantee uniqueness.
10,009 total views, 3 views today
SQL DROP TABLE statement is used to delete the table from database.
1,333 total views
SQL ALTER TABLE statement is used to modify the data type of a column , add a new column ,delete an old column from table and add a new constraints and remove an existing constraints on table.
1,795 total views, 1 views today
SQL CREATE TABLE statement is used to create a new table in a database.
3,094 total views
SQL SELECT INTO statement copies data from one table into new table.
1,308 total views
SQL INSERT INTO SELECT statement selects data from one table and insert it into another table.
1,726 total views, 1 views today
SQL SERVER DISTINCT keyword is used to remove all the duplicate records and fetching only unique records from any table.
876 total views
SQL server SELECT Statement is used to fetch the data from any table .
1,342 total views, 3 views today