Matches in SemOpenAlex for { <https://semopenalex.org/work/W9166111> ?p ?o ?g. }
Showing items 1 to 82 of
82
with 100 items per page.
- W9166111 abstract "There are a number of database objects in SQL:1999, such as schemas, catalogs, views, users, privileges, domains, connections, sessions, transactions, routines, and paths. SQL's Data Definition Language (DDL) has facilities that define not only tables and columns but also other database objects. This chapter discusses those facilities and demonstrates how a user can modify, and delete these objects through DDL. Tables are the basic unit of data management that is encountered in SQL and are embedded in a nested structure of increasing abstractions. The degree of a table is the number of columns in that table, and the cardinality of a table is the number of rows it contains. A table whose cardinality is zero is said to be empty. Based on it, a table is either a base table, a viewed table, or a derived table. Catalogs, on the other hand, are named collections of schemas in an SQL environment. An SQL environment contains zero or more catalogs, and a catalog contains one or more schemas. The chapter discusses the properties of tables, catalogs, and schemas. The DDL have the CREATE, ALTER, and DROP statements, which are analogs of the manipulation statements INSERT, UPDATE, and DELETE, respectively; however, the SELECT statement is used for data retrieval in both data manipulation and data definition languages. The chapter closes with a discussion on optional syntax WITH CHECK OPTION that can be added to a view definition." @default.
- W9166111 created "2016-06-24" @default.
- W9166111 creator A5025842264 @default.
- W9166111 creator A5076244812 @default.
- W9166111 date "2002-01-01" @default.
- W9166111 modified "2023-09-27" @default.
- W9166111 title "Basic Data Definition Language (DDL)" @default.
- W9166111 doi "https://doi.org/10.1016/b978-155860456-8/50005-9" @default.
- W9166111 hasPublicationYear "2002" @default.
- W9166111 type Work @default.
- W9166111 sameAs 9166111 @default.
- W9166111 citedByCount "0" @default.
- W9166111 crossrefType "book-chapter" @default.
- W9166111 hasAuthorship W9166111A5025842264 @default.
- W9166111 hasAuthorship W9166111A5076244812 @default.
- W9166111 hasConcept C135598885 @default.
- W9166111 hasConcept C154420247 @default.
- W9166111 hasConcept C162319229 @default.
- W9166111 hasConcept C164120249 @default.
- W9166111 hasConcept C167544706 @default.
- W9166111 hasConcept C17744445 @default.
- W9166111 hasConcept C194222762 @default.
- W9166111 hasConcept C199360897 @default.
- W9166111 hasConcept C199539241 @default.
- W9166111 hasConcept C23123220 @default.
- W9166111 hasConcept C2777026412 @default.
- W9166111 hasConcept C41008148 @default.
- W9166111 hasConcept C45235069 @default.
- W9166111 hasConcept C48859967 @default.
- W9166111 hasConcept C510870499 @default.
- W9166111 hasConcept C55596503 @default.
- W9166111 hasConcept C56288433 @default.
- W9166111 hasConcept C77088390 @default.
- W9166111 hasConcept C87117476 @default.
- W9166111 hasConcept C97854310 @default.
- W9166111 hasConceptScore W9166111C135598885 @default.
- W9166111 hasConceptScore W9166111C154420247 @default.
- W9166111 hasConceptScore W9166111C162319229 @default.
- W9166111 hasConceptScore W9166111C164120249 @default.
- W9166111 hasConceptScore W9166111C167544706 @default.
- W9166111 hasConceptScore W9166111C17744445 @default.
- W9166111 hasConceptScore W9166111C194222762 @default.
- W9166111 hasConceptScore W9166111C199360897 @default.
- W9166111 hasConceptScore W9166111C199539241 @default.
- W9166111 hasConceptScore W9166111C23123220 @default.
- W9166111 hasConceptScore W9166111C2777026412 @default.
- W9166111 hasConceptScore W9166111C41008148 @default.
- W9166111 hasConceptScore W9166111C45235069 @default.
- W9166111 hasConceptScore W9166111C48859967 @default.
- W9166111 hasConceptScore W9166111C510870499 @default.
- W9166111 hasConceptScore W9166111C55596503 @default.
- W9166111 hasConceptScore W9166111C56288433 @default.
- W9166111 hasConceptScore W9166111C77088390 @default.
- W9166111 hasConceptScore W9166111C87117476 @default.
- W9166111 hasConceptScore W9166111C97854310 @default.
- W9166111 hasLocation W91661111 @default.
- W9166111 hasOpenAccess W9166111 @default.
- W9166111 hasPrimaryLocation W91661111 @default.
- W9166111 hasRelatedWork W1010596898 @default.
- W9166111 hasRelatedWork W132823900 @default.
- W9166111 hasRelatedWork W1580423347 @default.
- W9166111 hasRelatedWork W2391818964 @default.
- W9166111 hasRelatedWork W2474075731 @default.
- W9166111 hasRelatedWork W257465271 @default.
- W9166111 hasRelatedWork W195032706 @default.
- W9166111 hasRelatedWork W2198178031 @default.
- W9166111 hasRelatedWork W2839978699 @default.
- W9166111 hasRelatedWork W2845400017 @default.
- W9166111 hasRelatedWork W2847222045 @default.
- W9166111 hasRelatedWork W2858835251 @default.
- W9166111 hasRelatedWork W2923936289 @default.
- W9166111 hasRelatedWork W2926912035 @default.
- W9166111 hasRelatedWork W2928058141 @default.
- W9166111 hasRelatedWork W2976972578 @default.
- W9166111 hasRelatedWork W3102934628 @default.
- W9166111 hasRelatedWork W3172759977 @default.
- W9166111 hasRelatedWork W3179590061 @default.
- W9166111 hasRelatedWork W959164222 @default.
- W9166111 isParatext "false" @default.
- W9166111 isRetracted "false" @default.
- W9166111 magId "9166111" @default.
- W9166111 workType "book-chapter" @default.