正在加载图片...
Structured Types and Inheritance in SQL Structured types can be declared and used in SQL create type Name as (firstname varchar(20), lastname varchar(20)) final create type Address as (street varchar(20), city varchar(20), zipcode varchar(20)) not final Note:final and not final indicate whether subtypes can be created Structured types can be used to create tables with composite attributes create table customer( name Name, addressAddress, dateOfBirth date) Dot notation used to reference components:name.firstname Database System Concepts-5th Edition,Aug 9,2005. 9.10 ©Silberschat乜,Korth and SudarshanDatabase System Concepts - 5 9.10 ©Silberschatz, Korth and Sudarshan th Edition, Aug 9, 2005. Structured Types and Inheritance in SQL Structured types can be declared and used in SQL create type Name as (firstname varchar(20), lastname varchar(20)) final create type Address as (street varchar(20), city varchar(20), zipcode varchar(20)) not final Note: final and not final indicate whether subtypes can be created Structured types can be used to create tables with composite attributes create table customer ( name Name, address Address, dateOfBirth date) Dot notation used to reference components: name.firstname
<<向上翻页向下翻页>>
©2008-现在 cucdc.com 高等教育资讯网 版权所有