Posts

Important SQL Topics

Image
  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