¿©·¯ °³ÀÇ ±¸º° À¯ÇüÀ» Á¤ÀÇÇÑ ÈÄ, À¯ÇüÀÌ ±¸º° À¯ÇüÀÎ Ä÷³À¸·Î Å×À̺íÀ» Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½Àº CREATE TABLE »ç¿ë ¿¹ÀÔ´Ï´Ù.
´Ù¸¥ ³ª¶ó¿¡¼ÀÇ »ç¿ëÀÚ È¸»ç ÆÇ¸Å ÇöȲÀ» ±â·ÏÇϱâ À§ÇØ ´ÙÀ½°ú °°ÀÌ Å×À̺íÀ» Á¤ÀÇÇÑ´Ù°í °¡Á¤ÇϽʽÿÀ.
CREATE TABLE US_SALES (PRODUCT_ITEM INTEGER, MONTH INTEGER CHECK (MONTH BETWEEN 1 AND 12), YEAR INTEGER CHECK (YEAR > 1985), TOTAL US_DOLLAR) CREATE TABLE CANADIAN_SALES (PRODUCT_ITEM INTEGER, MONTH INTEGER CHECK (MONTH BETWEEN 1 AND 12), YEAR INTEGER CHECK (YEAR > 1985), TOTAL CANADIAN_DOLLAR) CREATE TABLE GERMAN_SALES (PRODUCT_ITEM INTEGER, MONTH INTEGER CHECK (MONTH BETWEEN 1 AND 12), YEAR INTEGER CHECK (YEAR > 1985), TOTAL EURO)
À§ ¿¹¿¡¼ ±¸º° À¯ÇüÀº ¿¹: ºñ¿ë¿¡¼ µ¿ÀÏÇÑ CREATE DISTINCT TYPE¹®À» »ç¿ëÇÏ¿© ÀÛ¼ºµË´Ï´Ù. ÀÌ ¿¹¿¡¼´Â Á¡°Ë Á¦ÇÑÁ¶°ÇÀ» »ç¿ëÇÕ´Ï´Ù. Á¡°Ë Á¦ÇÑÁ¶°Ç¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº SQL ÂüÁ¶¼ÀÇ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
±¸Á÷ÀÚ°¡ ÀÛ¼ºÇÑ ¾ç½ÄÀ» ±â·ÏÇÏ´Â Å×À̺íÀ» ´ÙÀ½°ú °°ÀÌ Á¤ÀÇÇØ¾ß ÇÑ´Ù°í °¡Á¤ÇϽʽÿÀ.
CREATE TABLE APPLICATIONS (ID SYSIBM.INTEGER, NAME VARCHAR (30), APPLICATION_DATE SYSIBM.DATE, FORM PERSONAL.APPLICATION_FORM)
±ÔÁ¤ÀÚ°¡ »ç¿ëÀÚÀÇ ±ÇÇÑ ºÎ¿© ID¿Í °°Áö ¾Ê°í ±âº» ÇÔ¼ö °æ·Î¸¦ º¯°æÇÏÁö ¾Ê¾ÒÀ¸¹Ç·Î ±¸º° À¯Çü À̸§À» ¿ÏÀüÈ÷ ±ÔÁ¤Çß½À´Ï´Ù. À¯Çü ¹× ÇÔ¼ö À̸§ÀÌ ¿ÏÀü ±ÔÁ¤µÇÁö ¾ÊÀ» ¶§¸¶´Ù DB2´Â ÇöÀç ÇÔ¼ö °æ·Î¿¡ ³ª¿µÈ ½ºÅ°¸¶¸¦ °Ë»öÇϰí, ±ÔÁ¤µÇÁö ¾ÊÀº ÇöÀç À̸§°ú ÀÏÄ¡ÇÏ´Â ÇÔ¼ö À̸§ ¶Ç´Â À¯ÇüÀ» °Ë»öÇÕ´Ï´Ù. ÇöÀç ÇÔ¼ö °æ·Î¿¡¼ (»ý·«µÈ °æ¿ì) SYSIBMÀÌ Ç×»ó °í·ÁµÇ¹Ç·Î ³»Àå µ¥ÀÌÅÍ À¯ÇüÀÇ ±ÔÁ¤À» »ý·«ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, SET CURRENT FUNCTION PATH = cherylÀ» ½ÇÇàÇÒ ¼ö ÀÖ°í, ÇöÀç ÇÔ¼ö °æ·Î Ư¼ö ·¹Áö½ºÅÍ °ªÀº "CHERYL"ÀÌ µÇ°í, "SYSIBM"ÀÌ Æ÷ÇÔµÇÁö ¾Ê½À´Ï´Ù. ÀÌÁ¦, CHERYL.INTEGER À¯ÇüÀÌ Á¤ÀǵÇÁö ¾Ê¾Ò´Ù¸é, CREATE TABLE FOO(COL1 INTEGER)¹®Àº SYSIBMÀÌ Ç×»ó SYSIBM.INTEGER À¯ÇüÀÇ COL1·Î¼ °í·ÁµÇ¹Ç·Î ¿©ÀüÈ÷ ¼º°øÇÕ´Ï´Ù.
±×·¯³ª, ¿øÇÒ °æ¿ì ³»Àå µ¥ÀÌÅÍ À¯ÇüÀ» ¿ÏÀüÈ÷ ±ÔÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇöÀç ÇÔ¼ö °æ·Î »ç¿ë¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº SQL ÂüÁ¶¼¿¡ ÀÖ½À´Ï´Ù.