0
Some of the operations performed in DDL in sql are creation of table,alteration of table,truncate a table, drop a table
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Difference between alter and update commands in sql?
Update and Alter are two SQL (Structured Query Language) commands used for modifying databases. Update statement is used to update existing records in a database. Update is a Data Manipulation Language (DML) statement. Alter SQL command is used to modify, delete or add a column to an existing table in a database. Alter is a Data Definition Language (DDL) statement.Commands that are used to define the structure of a database (database schema) are called DDL statements.
What are the two major components of SQL and what function do they serve?
The Data Definition Language (DDL). This component of the SQL language is used to create and modify tables and other objects in the database. For tables there are three main commands:CREATE TABLE tablename to create a table in the databaseDROP TABLE tablename to remove a table from the databaseALTER TABLE tablename to add or remove columns from a table in the database.The Data Manipulation Language (DML) component of the SQL language is used to manipulate data within a table. There are four main commands:then,SELECT to select rows of data from a tableINSERT to insert rows of data into a tableUPDATE to change rows of data in a tableDELETE to remove rows of data from a table
Full meaning of the acronyms dml and ddl state difference within the two?
Details is discussed on http://arjudba.blogspot.com/2008/04/what-are-difference-between-ddl-dml-and.html
How many types of wildcards in sql?
two - * and ?
What are two method of retrieving SQL?
1.what cursor type do you use to retrieve multiple recordsets? 2.What are two methods of retrieving SQL?
In SQL what is the function of the union operator?
In SQL, the function of the union operator is to combine the result of two or more select-statements. The union operator is a very useful tool when coding SQL.
Name two of the operations launched against the Taliban by the US?
potato and salad
What does an SQL join combine?
A SQL join clause combines records from two or sometimes more than two tables in to a database. This creates a set that can be used as it is or can be saved as a table.
What are two database software programs?
SQL Server Oraclel
What are the are two sort functions for columns in SQL?
Asc & desc
Two examples of database?
1. oracle 2. My SQL
What are the two last operations in the order of operations?
The last two operations in P.E.M.D.A.S are 'addition' and 'subtraction'.
