create table teacher4(
tname varchar(10) NOT NULL ,
tno char(3),
sex char(2)
);
它硬说不支持,,我去掉not null后就可以了,,这是为什么呢??
另,,如何指定主键等一些约束条件呢??
tname varchar(10) NOT NULL ,
tno char(3),
sex char(2)
);
它硬说不支持,,我去掉not null后就可以了,,这是为什么呢??
另,,如何指定主键等一些约束条件呢??
解决方案 »
- 请问:谁有MAPX 5 的控件?
- 如何比较两个tclientdataset的数据集
- 请教如何定位鼠标指针到一个批定位置?
- 请问使用ADOConnection如何枚举所有的表名
- 帮我介绍几本初学delphi的书籍吧!谢谢大家!!!
- 100分求问关于流水号的简单问题!!!
- 调用计划任务
- 请问那里可以得到有关DELPHI自带的所有控件的说明和解释??
- delphi perform()与SendMessage()有什么区别,前者在什么情况下应用.能不能给个例子
- 高手请进,如何运行内存映射文件?
- 高难度问题(listview),看看不用第三方控件能否解决?
- 新手上路,初来报到,征集各位的QQ及email,以备随时请教!来者有分
local sql-over view-conventions-unsupported languageThe following SQL-92 language elements are not used in local SQL.ALLOCATE CURSOR (Command)ALLOCATE DESCRIPTOR (Command)ALTER DOMAIN (Command)CASE (Expression)CHECK (Constraint)CLOSE (Command)COALESCE (Expression)COMMIT (Command)CONNECT (Command)CONVERT (Function)CORRESPONDING BY (Expression)CREATE ASSERTION (Command)CREATE CHARACTER SET (Command)CREATE COLLATION (Command)CREATE DOMAIN (Command)CREATE SCHEMA (Command)CREATE TRANSLATION (Command)CREATE VIEW (Command)CROSS JOIN (Relational operator)CURRENT_DATE (Function)CURRENT_TIME (Function)CURRENT_TIMESTAMP (Function)DEALLOCATE DESCRIPTOR (Command)DEALLOCATE PREPARE (Command)DECLARE CURSOR (Command)DECLARE LOCAL TEMPORARY TABLE (Command)DESCRIBE (Command)DISCONNECT (Command)DROP ASSERTION (Command)DROP CHARACTER SET (Command)DROP COLLATION (Command)DROP DOMAIN (Command)DROP SCHEMA (Command) DROP TRANSLATION (Command)DROP VIEW (Command)EXCEPT (Relational operator)EXECUTE (Command)EXECUTE IMMEDIATE (Command)FETCH (Command)FOREIGN KEY (Constraint)GET DESCRIPTOR (Command)GET DIAGNOSTICS (Command)GRANT (Command)INTERSECT (Relational operator)MATCH (Predicate)NATURAL (Relational operator)NULLIF (Expression)OPEN (Command)OVERLAPS (Predicate)PREPARE (Command)REFERENCES (Constraint)REVOKE (Command)ROLLBACK (Command)Row value constructorsSET CATALOG (Command)SET CONNECTION (Command)SET CONSTRAINTS MODE (Command)SET DESCRIPTOR (Command)SET NAMES (Command)SET SCHEMA (Command)SET SESSION AUTHORIZATION (Command)SET TIME ZONE (Command)SET TRANSACTION (Command)TRANSLATE (Function)UNIQUE (Predicate)USING (Relational operator)
d_id char(3) not null,
d_name char(20) not null,
manager char(6),
intro varchar(4000),
constraint department_id primary key(d_id));varchar不能not null?
不太清楚
你可以在查询分析器中,Shift + F1查看关于Create table的帮助,那上面说的很清楚,靠别人告诉你,毕竟是很少,很多东西还是得自己去查找!有些时候,做一些事情不要总是拘泥于一种方法!可以自己多试一些方法,多找一途径,这样你才会进步!