怎样才能用SQL语言在数据库建表? (100分)

怎样才能用SQL语言在数据库建表以及设定相应的字段。如果有人回答了这个问题，请用
EMail通知我。好吗？谢谢了！Cyun@cd163.net。

CREATE TABLE table_reference (column_definition [, column_definition,...] [, primary_key_constraint])

例如在SQL Server中建议一个雇员表，以F_ID为索引
CREATE TABLE [T_Employee] (
[F_ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[F_HasDelete] [varchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_T_Employee_F_HasDelete] DEFAULT ('F'),
[F_EmployeeName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[F_EmployeeNum] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[F_IsOperationer] [varchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_T_Employee_F_IsOperationer] DEFAULT ('F'),
[F_InActive] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_T_Employee_F_InActive] DEFAULT ('F'),
[F_BirthDay] [datetime] NULL ,
[F_Sex] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_T_Employee_F_Sex] DEFAULT ('男'),
[F_DeptID] [numeric](18, 0) NULL ,
[F_ELeveID] [numeric](18, 0) NULL ,
[F_EmployeeClassID] [numeric](18, 0) NULL ,
[F_BeginDate] [datetime] NULL ,
[F_IDCardNum] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[F_Tel] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[F_NativePlace] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[F_PayModeID] [numeric](18, 0) NULL ,
[F_MailMan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[F_EMail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[F_HomeTEL] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[F_JobTEL] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[F_Address] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[F_DutyName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[F_BasePay] [money] NULL ,
[F_Remark] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
CONSTRAINT [PK_T_Employee] PRIMARY KEY CLUSTERED
(
[F_ID]
) ON [PRIMARY]
) ON [PRIMARY]

如：
CREATE TABLE "employee.db"
( Last_Name CHAR(20),
First_Name CHAR(15),
Salary NUMERIC(10,2),
Dept_No SMALLINT,
PRIMARY KEY (Last_Name, First_Name)
)

建表太简单了，！

建表只要掌握SQL语法就可以了，具体的写法要看你使用的什么数据库系统，
SQL Server 和 Oracle的语法有一点区别
掌握了语法后，如果你使用的登录用户有足够的权限，你就可以动态建立数据表了