Please enable JavaScript.
Coggle requires JavaScript to display documents.
Using SQL (Column data types (INTEGER (INT), SMALLINT, NUMERIC, DECIMAL,…
Using SQL
-
-
-
Schemas
To a database designer, a schema represents the overall, logical design of a complete database
To SQL a schema is a container for tables, views and other structural elements
-
Tables
-
Global temporary tables - for working storage that is destroyed at the end of an SQL session and visible to an entire SQL session
Local temporary tables - similar to global, aside from they are only visible to the specific program module in which they are created
-
-
-
-
Foreign keys
is a column that is exactly the same as a primary in another table, it shows there is a logical relationship between the database objects