· »ç¿ëÁ¦Ç°: All
Microsoft SQL Server ÇÁ·Î±×·¥ ¸Þ´ºÀÇ Enterprise Manager¸¦ »ç¿ëÇÏ¿© GUI ȯ°æ¿¡¼ Å×À̺íÀ» ¸¸µé ¼ö ÀÖ½À´Ï´Ù.
¶ÇÇÑ, Query Analyzer¸¦ »ç¿ëÇÏ¿© ¾Æ·¡¿Í °°Àº SQL Script¸¦ ½ÇÇàÇÏ¿© ¸¸µé ¼öµµ ÀÖ½À´Ï´Ù.
CREATE TABLE tblBbs_Free (
index_num int NOT NULL , /* ÀϷùøÈ£ */
no int NOT NULL , /* ±Û¹øÈ£ */
re_level int NOT NULL , /* ´äº¯·¹º§(Á¾) */
ref int NOT NULL , /* ´äº¯¼ö(Ⱦ) */
id varchar (20) NOT NULL , /* ±Û¾´ÀÌ ID or Nick Name */
pass varchar (20) NOT NULL , /* ºñ¹Ð¹øÈ£ */
title varchar (500) NOT NULL , /* Á¦¸ñ */
content text NOT NULL , /* ³»¿ë */
writeday datetime NOT NULL , /* ¿Ã¸°ÀϽà */
readnum int NOT NULL , /* Á¶È¸¼ö */
ip char (16) NOT NULL , /* IP ÁÖ¼Ò */
filename varchar (30) NULL , /* ÷ºÎ ÆÄÀÏ */
down int NOT NULL , /* ´Ù¿î·Îµå¼ö */
recommend int NOT NULL , /* Ãßõ¼ö */
email varchar (50) NULL , /* ¸ÞÀÏ */
CONSTRAINT tblBbs_Free_PK PRIMARY KEY NONCLUSTERED
(
index_num
)
)
Enterprise Manager ¹× Query Analyzer ¸Þ´º´Â MSDE¸¦ ¼³Ä¡Çß´Ù¸é Client Tools¸¦ º°µµ·Î ¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. |