Important SQL Topics
SQL Server : SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft . DDL Data Definition Language (DDL) is a standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users. Common DDL statements are CREATE, ALTER, and DROP. CREATE ( This command is used to create the database or its objects (like table, index, function, views, store procedure, and triggers)) CREATE TABLE table_name ( column1 data_type(size), column2 data_type(size), column3 data_type(size), .... ); DROP ( This command is used to delete objects from the database. ) DROP object object_name ALTER (This is used to alter the structure of the database.) ALTER TABLE table_name ADD (Columnname_1 datatype, Columnname_2 datatype, … Columnname_n datatype); TRUNCATE (This is used to remove all records from a table, including all space