A data definition language or data description language ( DDL ) is a syntax similar to a computer programming language for defining data structures , especially database schemas . Many data description languages use a declarative syntax to define columns and data types. Structured query language (e.g., SQL), however, uses a collection of imperative verbs whose effect is to modify the schema of the database by adding, changing, or deleting definitions of tables or other elements. These statements can be freely mixed with other SQL statements, making the DDL not a separate language. CREATE statement Edit The create command is used to establish a new database, table, index, or stored procedure . The CREATE statement in SQL creates a component in a relational database management system (RDBMS). In the SQL 1992 specification, the types of components that can be created...
Comments
Post a Comment
8368456574