Write a postgre SQL statement to create a table countries, including country_id, country_name and region_id and make sure that the combination of columns country_id and region_id will be unique

  • Postgre SQL

Write a  postgreSQL statement to create a table countries, including country_id, country_name and region_id and make sure that the combination of columns country_id and region_id will be unique.

الأجوبة

CREATE TABLE IF NOT EXISTS countries_n (
COUNTRY_ID varchar(2) NOT NULL UNIQUE DEFAULT '',
COUNTRY_NAME varchar(40) DEFAULT NULL,
REGION_ID decimal(10,0) NOT NULL,
PRIMARY KEY (COUNTRY_ID,REGION_ID));

Output:

postgres=# CREATE TABLE IF NOT EXISTS countries (
postgres(# COUNTRY_ID varchar(2) NOT NULL UNIQUE DEFAULT '',
postgres(# COUNTRY_NAME varchar(40) DEFAULT NULL,
postgres(# REGION_ID decimal(10,0) NOT NULL,
postgres(# PRIMARY KEY (COUNTRY_ID,REGION_ID));
CREATE TABLE

Here is the command to see the structure of the created table :

postgres=# \d countries
                          Table "public.countries"
    Column    |         Type          |               Modifiers
--------------+-----------------------+----------------------------------------
 country_id   | character varying(2)  | not null default ''::character varying
 country_name | character varying(40) | default NULL::character varying
 region_id    | numeric(10,0)         | not null
Indexes:
    "countries_pkey" PRIMARY KEY, btree (country_id, region_id)
    "countries_country_id_key" UNIQUE CONSTRAINT, btree (country_id)
سجل الدخول لتستطيع الإجابة
هل كان المحتوى مفيد؟

0 نعم

0 لا

أسئلة مشابهة

Write a postgre SQL statement to create a table countries including columns country_id, country_name and region_id and make sure that the column country_id will be unique and store an auto-incremented value
Write a postgre SQL statement to create a table named countries, including country_id, country_name and region_id and make sure that no countries except Italy, India and China will be entered in the table
Write a postgre SQL statement to create a table named countries, including country_id, country_name and region_id and make sure that no duplicate data against column country_id will be allowed at the time of insertion
Write a postgre SQL statement to create a simple table countries, including columns country_id, country_name and region_id

القوائم الدراسية التي ينتمي لها السؤال

معلومات ذات صلة

تبحث عن مدرس اونلاين؟

ابحث عن مدرسك
محتاج مساعدة باختيار المدرس الافضل؟ تواصل مع فريقنا الان لمساعدتك بتأمين افضل مدرس
ماهو التخصص الذي تبحث عنه؟
اكتب هنا...