题目内容
创建表成绩(学号,课程号,成绩)的同时定义 CHECK约束要求成绩的范围为0-100。sql实现为:CREATE TABLE 成绩(学号 char(8) not null, 课程号 char(8) not null, 成绩 int CHECK(成绩>=0 and 成绩<=100) )
查看答案
搜索结果不匹配？点我反馈
更多问题
为存在的成绩表(学号,课程号,成绩)定义 CHECK约束要求成绩的范围为0-100。sql语言实现为:ALTER TABLE 成绩ADD CONSTRAINT ck_cj CHECK(成绩>=0 and 成绩<=100)
删除成绩表中的CHECK约束,sql实现语言是: ALTER 成绩DROP CONSTRAINT ck_cj
用户定义完整性约束有以下几种:NOT NULL、CHECK、DEFAULT和 UNIQUE等约束。
[音频]Everyone needs friendship. No one can sail the ocean of life single-handed. We need help from, and also give help to, others. In the modern age, people ______ more importance to relations and connections. A man of charisma has many friends. His power lies in his ability to give.
微信支付 
支付宝支付