Thursday, 20 February 2014

SQL command Groups

Leave a Comment
Data Query Language (DQL) statement used querying databaseSELECT ‐ used to retrieve the data present in the database Data Definition Language (DDL) statements are used to define the databasestructure or schema.CREATE ‐ to create objects in the databaseALTER ‐ alters the structure of the databaseDROP ‐ delete objects from the databaseTRUNCATE ‐ remove all records from a table permanentlyCOMMENT ‐ add comments to the data dictionaryRENAME ‐ rename an object Data Manipulation Language (DML) statements are used for managing datawithin...
Read More...