query.sql.clear; query.sql.add('create table tabxxx (id char(10),...)'); query.sql.execsql
with Query do begin SQL.Clear; SQL.Add('CREATE TABLE Tablename ' + '(fieldName fieldtype'); ExecSQL; end;
tfxg(土匪) 能不能不说废话
1、创建数据库可以这样: IF EXISTS (SELECT * FROM sysdatabases WHERE name = '数据库名称') BEGIN DROP database 数据库名称 END; CREATE database 数据库名称;2、创建表: IF EXISTS (SELECT * FROM sysobjects WHERE name = '表名') BEGIN DROP TABLE 表名 END; CREATE TABLE 表名 ( 字段ID int not null IDENTITY, 字段1 varchar(16) primary key, 字段2 varchar(100) not null, ...... 字段n varchar(100) not null
SQL.Clear;
SQL.Add('CREATE TABLE TestTable ' +
'(Name char(8), Age number)');
ExecSQL;
end;
' (A1 TEXT(20) NOT NULL PRIMARY KEY,A2 TEXT(100),A2_1 SMALLINT,'+
'A3 TEXT(9),A4 TEXT(9),A5 TEXT(9),A6 TEXT(9),A7 TEXT(9),A8 TEXT(9),A9 TEXT(9)'+
',A10 TEXT(4),A13 SMALLINT,A14 MEMO,E1 DATETIME,E2 TEXT(100),'+
'E2_1 TEXT(100),E3 SMALLINT,E4 SMALLINT,jx MEMO,csbs TEXT(2),'+
'F1 SMALLINT)';
其余为字段及其属性
query.sql.add('create table tabxxx (id char(10),...)');
query.sql.execsql
SQL.Clear;
SQL.Add('CREATE TABLE Tablename ' +
'(fieldName fieldtype');
ExecSQL;
end;
IF EXISTS (SELECT *
FROM sysdatabases
WHERE name = '数据库名称')
BEGIN
DROP database 数据库名称
END;
CREATE database 数据库名称;2、创建表:
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = '表名')
BEGIN
DROP TABLE 表名
END;
CREATE TABLE 表名
(
字段ID int not null IDENTITY,
字段1 varchar(16) primary key,
字段2 varchar(100) not null,
......
字段n varchar(100) not null