sql创建表格是怎么写的。。最好有具体的示例！

DROP TABLE CELL_TCH;

DROP TABLE MS;

DROP TABLE MSC;

DROP TABLE BSC;

DROP TABLE BTS;

DROP TABLE CELL;

DROP TABLE ANTENNA;

DROP TABLE DATA;

DROP TABLE TEST;

DROP TABLE NEIGHBOR;

CREATE TABLE MSC (

MSCID INTEGER NOT NULL,

MSCNAME CHARACTER (10),

MSCCOMPANY CHARACTER (10),

MSCLONGITUDE DECIMAL (9,6),

MSCLATITUDE DECIMAL (8,6),

MSCALTITUDE INTEGER,

PRIMARY KEY ( MSCID) ) ;

CREATE TABLE BSC (

BSCID INTEGER NOT NULL,

BSCNAME CHARACTER (10),

BSCCOMPANY CHARACTER (10),

LONGITUDE DECIMAL (9,6),

LATITUDE DECIMAL (8,6),

MSCID INTEGER,

PRIMARY KEY (BSCID),

FOREIGN KEY (MSCID) REFERENCES MSC (MSCID)) ;

CREATE TABLE BTS (

BTSNAME CHARACTER (20) NOT NULL,

BSCID INTEGER NOT NULL,

LONGITUDE DECIMAL (9,6),

LATITUDE DECIMAL (8,6),

ALTITUDE INTEGER,

BTSCOMPANY CHARACTER (10),

BTSPOWER DECIMAL (2,1),

PRIMARY KEY (BTSNAME),

FOREIGN KEY (BSCID) REFERENCES BSC (BSCID)) ;

CREATE TABLE CELL (

CELLID INTEGER NOT NULL,

BTSNAME CHARACTER (20),

AREANAME CHARACTER (10),

LAC INTEGER,

LONGITUDE DECIMAL (9,6),

LATITUDE DECIMAL (8,6),

DIRECTION INTEGER,

RADIOUS INTEGER,

ANTNUM INTEGER,

BCCH INTEGER,

PRIMARY KEY ( CELLID),

FOREIGN KEY (BTSNAME) REFERENCES BTS (BTSNAME)) ;

CREATE TABLE MS (

IMEI BIGINT NOT NULL,

MSISDN BIGINT,

USERNAME VARCHAR(10),

MSCOMPANY VARCHAR (20),

GSMMSPSENSE INTEGER,

GSMMSHEIGHT DECIMAL (3,2),

GSMMSPFOUT DECIMAL (3,2),

MZONE CHARACTER (10),

CELLID INTEGER,

PRIMARY KEY ( IMEI),

FOREIGN KEY (CELLID) REFERENCES CELL (CELLID)) ;

CREATE TABLE ANTENNA (

CELLID INTEGER NOT NULL,

ANTENNAHIGH INTEGER,

HALFPANGLE INTEGER,

MAXATTENUATION INTEGER,

GAIN INTEGER,

ANTTILT INTEGER,

PT INTEGER,

MSPWR INTEGER,

PRIMARY KEY ( CELLID));

CREATE TABLE CELL_TCH (

CELLID INTEGER,

FREQ INTEGER,

FOREIGN KEY (CELLID) REFERENCES CELL (CELLID));

CREATE TABLE DATA (

DATE INTEGER NOT NULL,

TIME INTEGER NOT NULL,

CELLID INTEGER NOT NULL,

NTCH INTEGER,

TRAFF DECIMAL (9,7),

RATE DECIMAL (10,9),

THTRAFF DECIMAL (9,7),

CALLNUM INTEGER,

CONGSNUM INTEGER,

CALLCONGS DECIMAL (10,9),

PRIMARY KEY ( DATE,TIME,CELLID)) ;

CREATE TABLE TEST (

KEYNUM INTEGER NOT NULL,

CELLID INTEGER,

LATITUDE DECIMAL (9,6),

LONGITUDE DECIMAL (8,6),

RXLEV DECIMAL (9,6),

PRIMARY KEY ( KEYNUM),

FOREIGN KEY (CELLID) REFERENCES CELL (CELLID));

CREATE TABLE NEIGHBOR (

CELLID INTEGER,

ADJCELLID INTEGER,

CELLLAC INTEGER,

ADJCELLLAC INTEGER,

FOREIGN KEY (CELLID) REFERENCES CELL (CELLID));

IMPORT FROM "C:msc.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6) MESSAGES "1" INSERT INTO DB2ADMIN.MSC (MSCID, MSCNAME, MSCCOMPANY, MSCLONGITUDE, MSCLATITUDE, MSCALTITUDE);

IMPORT FROM "C:sc.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6) MESSAGES "1" INSERT INTO DB2ADMIN.BSC (BSCID, BSCNAME, BSCCOMPANY, LONGITUDE, LATITUDE, MSCID);

IMPORT FROM "C:ts.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7) MESSAGES "1" INSERT INTO DB2ADMIN.BTS (BTSNAME, BSCID, LONGITUDE, LATITUDE, ALTITUDE, BTSCOMPANY, BTSPOWER);

IMPORT FROM "C:cell.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) MESSAGES "1" INSERT INTO DB2ADMIN.CELL (CELLID, BTSNAME, AREANAME, LAC, LONGITUDE, LATITUDE, DIRECTION, RADIOUS, ANTNUM, BCCH);

IMPORT FROM "C:data.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) MESSAGES "1" INSERT INTO "DATA" (DATE, TIME, CELLID, NTCH, TRAFF, RATE, THTRAFF, CALLNUM, CONGSNUM, CALLCONGS);

IMPORT FROM "C:ms.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9) MESSAGES "1" INSERT INTO DB2ADMIN.MS (IMEI, MSISDN, USERNAME, MSCOMPANY, GSMMSPSENSE, GSMMSHEIGHT, GSMMSPFOUT, MZONE, CELLID);

IMPORT FROM "C:Cell_TCH.csv" OF DEL METHOD P (1, 2) MESSAGES "1" INSERT INTO DB2ADMIN.CELL_TCH (CELLID, FREQ);

IMPORT FROM "C: est.csv" OF DEL METHOD P (1, 2, 3, 4, 5) MESSAGES "1" INSERT INTO DB2ADMIN.TEST (KEYNUM, CELLID, LATITUDE, LONGITUDE, RXLEV);

IMPORT FROM "C:antenna.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8) MESSAGES "1" INSERT INTO DB2ADMIN.ANTENNA (CELLID, ANTENNAHIGH, HALFPANGLE, MAXATTENUATION, GAIN, ANTTILT, PT, MSPWR);

IMPORT FROM "C: eighbor.csv" OF DEL METHOD P (1, 2, 3, 4) MESSAGES "1" INSERT INTO DB2ADMIN.NEIGHBOR (CELLID, ADJCELLID, CELLLAC, ADJCELLLAC);

自己写的SQL脚本，做数据库试验时写的。

create table student

(

自动编号 int identity(1,1)

学号 varchar(20) not null primary key

姓名 varchar(16) not null

所在班级 varchar(30)

...

)

或者

create table student

(

自动编号 int identity(1,1)

学号 varchar(20) not null

姓名 varchar(16) not null

所在班级 varchar(30)

...

primary key（学号）

)

说明：自动编号可有可无。

create table 表名

(

字段名 类型,

字段名 类型

)

这是建数据表。

但你说的建表格就不清楚了。

create table t1

(

tid int inentity (1,1) primary key,

tname varchar(20),

tpwd varchar(20)

)

关键看你的中文表格是什么格式的。补充一下问题吧