SQL SERVER

SQL Server Tutorials| Basics & Advance Concepts | Interview Question & Answer Series | SQL Server Tricks & Tips

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.

Primary Key VS Composite Key?

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.

SQL DROP TABLE

SQL DROP TABLE statement is used to delete the table from database.

SQL ALTER TABLE

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.