shooterwin 2005年03月20日
为什么我的.sql文件运行错误?
下面是.sql的部分文件
/*SET SQL DIALECT 3;*/
/* CREATE DATABASE 'd:\lfsofthotel\hoteldata.gdb' PAGE_SIZE 4096
DEFAULT CHARACTER SET */
/* Domain definitions */
CREATE DOMAIN "DOMAIN_BH" AS VARCHAR(5);
CREATE DOMAIN "DOMAIN_BZ" AS VARCHAR(60);
CREATE DOMAIN "DOMAIN_C10" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_C12" AS VARCHAR(12);
CREATE DOMAIN "DOMAIN_C16" AS VARCHAR(16);
CREATE DOMAIN "DOMAIN_C18" AS VARCHAR(18);
CREATE DOMAIN "DOMAIN_C2" AS VARCHAR(2);
CREATE DOMAIN "DOMAIN_C20" AS VARCHAR(20);
CREATE DOMAIN "DOMAIN_C4" AS VARCHAR(4);
CREATE DOMAIN "DOMAIN_C6" AS VARCHAR(6);
CREATE DOMAIN "DOMAIN_C7" AS VARCHAR(7);
CREATE DOMAIN "DOMAIN_C8" AS VARCHAR(8);
CREATE DOMAIN "DOMAIN_CURRENCY" AS FLOAT
DEFAULT 0;
CREATE DOMAIN "DOMAIN_DATETIME" AS TIMESTAMP;
CREATE DOMAIN "DOMAIN_DM" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_FS" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_LOGIC" AS CHAR(1)
DEFAULT 'F';
CREATE DOMAIN "DOMAIN_LXM" AS VARCHAR(30);
CREATE DOMAIN "DOMAIN_MC" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_MEMO" AS BLOB SUB_TYPE 0 SEGMENT SIZE 80;
CREATE DOMAIN "DOMAIN_SJ" AS CHAR(4);
CREATE DOMAIN "DOMAIN_SL" AS INTEGER
DEFAULT 0;
CREATE DOMAIN "DOMAIN_SLF" AS FLOAT
DEFAULT 0;
CREATE DOMAIN "DOMAIN_USEBH" AS VARCHAR(12);
CREATE DOMAIN "DOMAIN_XM" AS VARCHAR(8);
CREATE DOMAIN "DOMAIN_ZT" AS CHAR(1);

/* Table: BASICFMT, Owner: SYSDBA */

CREATE TABLE "BASICFMT"
(
"CLASS" "DOMAIN_BH",
"SDATE" "DOMAIN_C8",
"STIME" "DOMAIN_BH",
"LAST" "DOMAIN_SLF",
"NUMBER" "DOMAIN_C16"
);

/* Table: BH, Owner: SYSDBA */

CREATE TABLE "BH"
(
"D_YDBH" "DOMAIN_USEBH",
"D_YJBH" "DOMAIN_USEBH",
"D_KRBH" "DOMAIN_USEBH",
"D_ZDBH" "DOMAIN_USEBH",
"D_JZBH" "DOMAIN_USEBH",
"D_DCBH" "DOMAIN_USEBH"
);

/* Index definitions for all user tables */
CREATE INDEX "KFZT" ON "KFZT"("D_LCBH", "D_KFBH");
CREATE INDEX "YSKJZLSXFRQXMBH" ON "YSKJZLS"("D_XFRQ", "D_XMBH");
/* Grant Roles for this database */
/* Grant permissions for this database */

运行时提示“DOMAIN 附近有语法错误”怎么回事呢?
...全文
39 点赞 收藏 2
写回复
2 条回复

还没有回复,快来抢沙发~

发动态
发帖子
MS-SQL Server
创建于2007-09-28

1.4w+

社区成员

25.3w+

社区内容

MS-SQL Server相关内容讨论专区
社区公告
暂无公告