大家帮帮忙！多谢啦_PB

大家帮帮忙！谢谢啦
我想用在pb的代码中创建表、加字段，得怎么写啊？？

CONNECT USING sqlca;
sSql="CREATE TABLE [dbo].[zy_mxls] (&
[lshh] [char] (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,&
[plh] [int] NOT NULL ,&
[bm] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,&
[huowname] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,&
[xshy] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,&
[spid] [char] (11) COLLATE Chinese_PRC_CI_AS NOT NULL ,&
[spbh] [char] (11) COLLATE Chinese_PRC_CI_AS NULL ,&
[spmch] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,&
[sptm] [char] (15) COLLATE Chinese_PRC_CI_AS NULL ,&
[shpgg] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,&
[dw] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,&
[dj] [decimal](14, 4) NULL "
.
.
.

我找不到方法，不知道要怎么写.......

------解决方案--------------------

HTML code

string  MysqlMysql = "CREATE TABLE Employee "&        +"(emp_id integer not null,"&        +"dept_id integer not null, "&        +"emp_fname char(10) not null, "&        +"emp_lname char(20) not null)"EXECUTE IMMEDIATE :Mysql ;
------解决方案--------------------
CONNECT USING sqlca;  
sSql="CREATE TABLE zy_mxls (lshh char(11) NOT NULL ) "
EXECUTE IMMEDIATE :sSql;
if sqlca.slqcode<>0 then
messagebox('',sqlca.slqerrtext)
end if

测一下看看