Write a postgre SQL statement to create a simple table countries, including columns country_id, country_name and region_id

  • Postgre SQL

Write a  postgre SQL statement to create a simple table countries, including columns country_id, country_name and region_id.

الأجوبة

CREATE TABLE countries (
COUNTRY_ID varchar(3),
COUNTRY_NAME varchar(45) ,
REGION_ID decimal(10,0)
);

Output:

postgres=# CREATE TABLE countries (
postgres(# COUNTRY_ID varchar(3),
postgres(# COUNTRY_NAME varchar(45),
postgres(# REGION_ID decimal(10,0)
postgres(# );
CREATE TABLE

To see the structure of the created table :

postgres=# postgres=# \d countries;
           Table "public.countries"
    Column    |         Type          | Modifiers
--------------+-----------------------+-----------
 country_id   | character varying(3)  |
 country_name | character varying(45) |
 region_id    | numeric(10,0)         |
سجل الدخول لتستطيع الإجابة
هل كان المحتوى مفيد؟

0 نعم

0 لا

أسئلة مشابهة

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
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

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

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

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

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