Posts Tagged ‘ddl script’
5 Command DDL (Data Definition Language)
February 7, 2012 | 
Author Post an this is my project work on the SQL DML command … may be useful for readers wrote … 
Overview of the SQL …
SQL stands for Structured Query Language. SQL is a standard computer language for accessing and manipulating databases. The entire database applications on the market, both free and is licensed, adopt the SQL language for database processing. There are two types of command in SQL, the DDL and DML.
DDL (Data Definition Language) is a SQL command associated with the definition of a database and tables.Some basic commands are included in the DDL, among others.
A. CREATE
Function: CREATE Command is working to create a database or create a table inside the database.
Syntax: CREATE database_name database;
Parameters: -
Example: CREATE pharmacy database;
Explanation: CREATE command above will create a database with the name of the pharmacy.
2. SHOW
Function: This function SHOW Command to display the database or table that we created earlier.
Syntax: SHOW databases;
Parameters: -
Example: SHOW databases;
Explanation: The SHOW command above will show all the existing database.
3. USE
Function: USE Command is working to open / activate / enter the database we have created. Once we enter into the database we have created, then we can manipulate existing data, including to create a table in the database.
Syntax: USE database_name;
Parameters: -
Example: USE pharmacies;
Explanation: The command above will enable the database with the name of the pharmacy so that we can manipulate the data.
4. ALTER
Function: ALTER Command is working to change the structure of a table. Change here is not simply renew the existing table structure, but also changed the name of the field, adding a primary key, change the field type, or delete fields that have been made previously.
Syntax: ALTER TABLE table_name parameter_option;
Parameters: add, modify, drop
Example: ALTER TABLE ADD medication price int (6);
Explanation: The command above will add a field into the price of the drug table.
5. DROP
Function: DROP Command is working to remove, either database, table, or field that has been entered into the table.
Syntax: DROP TABLE table_name;
Parameters: -
Example: DROP TABLE supplier;
Explanation: The command above will remove the table supplier in the pharmacy database.
Posted in ddl script | 
Tags: computer language, data definition language, database explanation, database name, database parameters, DDL, ddl script, key change, pharmacy 2, pharmacy database, query language sql, sql command, sql dml, sql language, standard computer, structured query language, table structure | 
Comments Closed
Glance About Sybase Power Designer 11
build an information system that is fast, structured and effective. Sybase Power Designer 11
supports multiple modeling as follows:
• Business Process
• Data Modelling
• XML Modelling
• Application Modeling with UML
• Information Liquidity Modeling
• Integrated Modelling
data (data modeling) for then we will use to perform database design.
Simply put, to perform data modeling in Power Designer, we have to begin at
level Conceptual Data Model, where the data modeling is done using the method Entity
Relationship Diagram. In the CDM, data type that is used is general and not specific
against a particular database.
CDM that we have built. Power Designer has a lot of support for the target database, sowe
not to be confused about the type - the type of data used, because the Power Designer will
adjust as the data type that we defined earlier in the stage of the CDM.
The last stage is the script generates Data Definition Language (DDL) of the PDM that has been
is made. Through this we can generate the DDL objects - database objects (tables, triggers, views,
procedure) then DDL scripts so that we can execute the software of other databases such as Oracle
or MySQL, or we can also create a connection and execute it directly via the PowerDesigner.
Posted in ddl script | Tags: business process, conceptual data model, data definition language, database design, database objects, DDL, ddl script, entity relationship diagram, information system, liquidity, management business, oracle, powerdesigner, requirements management, second stage, target database | Comments Closed
What is DDL & DML?
DDL - Data Definition Language
is a collection of SQL commands used to create, modify and delete metadata structuresand definitions of database objects.DML - Data Manipulation Language
is a collection of SQL commands that are used for processing the contents of the data inthe table such as insert, modify and delete the contents of the data - and not associatedwith changes in the structure and data type definitions of database objects.Let us see from the definition and more examples in the following sections below.
DDL - Data Definition LanguageAs the definition described above, DDL is a set of SQL commands that are used to make(create), modify (alter) and delete (drop) the structure and data type definitions ofdatabase objects.
Objects in the database in question - in MySQL - is as follows:
database
table
View
index
Procedure (Stored Procedure)
function
trigger
example:
Making (CREATE)
CREATE DATABASE
CREATE FUNCTION
CREATE INDEX
CREATE PROCEDURE
CREATE TABLE
CREATE TRIGGER
CREATE VIEWChanges (ALTER & RENAME)
ALTER DATABASE
ALTER FUNCTION
ALTER PROCEDURE
ALTER TABLE
ALTER VIEW
RENAME TABLEElimination (DROP)
DROP DATABASE
DROP FUNCTION
DROP INDEX
DROP PROCEDURE
DROP TABLE
DROP TRIGGER
DROP VIEW
| OBJECT | CREATE | ALTER | DROP | RENAME |
| DATABASE | Yes | Yes | Yes | |
| FUNCTION | Yes | Yes | Yes | |
| INDEX | Yes | Yes | ||
| PROCEDURE | Yes | Yes | Yes | |
| TABLE | Yes | Yes | Yes | Yes |
| TRIGGER | Yes | Yes | ||
| VIEW | Yes | Yes | Yes |
Some DML Commands list of MySQL 5.0CALL
DELETE
DO
HANDLER
INSERT
LOAD DATA INFILE
REPLACE
SELECT
TRUNCATE
UPDATE
Posted in ddl script | Tags: amp, data base administrator, data definition language, data manipulation language, database objects, database table, DDL, ddl script, dml, drop index, matrix table, sql commands, sql statements, type definitions | Comments Closed
What is a DLL Cleaner?
What are DLL files?
Select DLL or dynamic link information is specific information, which are among the various programs represented there is more space available on your PC. Unfortunately, there are times when people find it difficult to remove such information, which changes out to be a terrible mistake. Because the information is used by some DLLs a variety of important programs on your PC, delete the information can not be unhappy. When this information is broken, the basic functions of the PC may be affected in the same way.
For your PC to function properly, the relationship described by information DLL must be present. If this information is broken, goes through your PC’s performance.
The cause of DLL errors
DLL errors occur when a particular softwaree is in place or removed on your PC. How softwaree other programs and share the same DLL file, it is likely that one of these may change or even delete the DLL. You can also find several variants of information as a DLL build on the programs you have. This can lead to performance of value for other programs.In this spirit, it is important that you create the edition establish appropriate DLL with other programs on your PC. This will ensure that all programs are working properly.
DLL errors can also occur when you have lower quality components, such as a hard drive or disk part of a faulty memory. You can also get a problem DLL if you have a Windows registry infected.
How can we fix DLL errors?
Whenever there is a problem of DLL, the psychological steps should be taken as soon as possible. You can choose to use a complete edition of Windows registry units with a DLL made clearer. You get what you have errors on your PC restored with the help of a reader of the Windows registry.
Requests an effective player windows registry all your PC and determines the DLL errors.Softwaree This also helps to restore DLL errors so that your career gets easier. Just configure the unit for softwaree Windows Registry and fix DLL errors is available with optional automatic reader program.
Products DLLs are valuable because they can remove all DLL errors on your PC, you can help your PC run faster. In addition, repair Windows Registry is softwaree PC that is able to function correctly as possible. If you notice that your PC does not work as fast as usual, you can use a DLL sharper.
The operating system can be played fast, safe and successful stuck with the Windows registry. You will be able to stimulate the operation of your PC if you get a disk of the Windows registry with a DLL in it clearer. It is not necessary to improve all components of your PC. You can find many products in the Windows registry by searching the Internet. In less than an hour you will have your PC running much faster than it was before with DLL errors faded.
Posted in ddl script | Tags: ddl script, desktop computers, dll errors, dll file, dll files, dynamic link, existence, faulty memory, hard drive, inappropriate actions, information dll, modern engineering, quality components, softwaree, variants, windows registry | Comments Closed
Understanding The Specifications Puzzle
2. DBA (Data Base Administrator) requires precise specifications to select a management technique appropriate file (eg DBMS) and produce the necessary data definition language (DDL) for that. It normally takes the form of a model database representing the logical relationships between data entities.
3. The analyst (aka, Systems Analyst, Systems Engineer, Systems Architect, Business Analyst) – requires specification of the information requirements of the end user to design a system solution. This is normally based on a definition of commercial activities of the user and / or decisions that must be supported. After the system design, the analyst product specifications required by the programmer and DBA to fulfill their part of the puzzle. In this perspective, the analyst is the translator between the user and programmer and DBA.
Each party has its own unique perspective to the puzzle, and as such, requires different “specifications”. To compound the problem, however, the role of the analyst greatly diminished over the years, leaving programmers to try to determine what the needs of end users, a skill they are generally not trained or suited for. To illustrate, I recall the history of the IT Director in a shoe manufacturing company that has received a call from corporate sales manager for help on a pressing problem. The Director has sent more than one of its programmers to meet the sales manager and discuss the problem. Basically, the manager wanted a sense of all footwear sales sorted by model, volume, type, color, etc. The programmer immediately knew how to access the necessary data and sorted accordingly, producing a large print (three feet high) he dutifully delivered to the user.
Posted in ddl script | Tags: classic gershwin song, data base administrator, data definition language, DDL, ddl script, engineer systems, hardware types, information requirements, logical relationships, management technique, model database, necessary data, precise specifications, software engineer, systems architect, systems engineer, timing messages | Comments Closed