Translate

Tuesday, October 29, 2024

How to Create Table in POSTGRESQL

Creating table in PostgreSQL is very much similar like MSSQL. Syntax is like below, 

 CREATE TABLE <TableName>
 (
    <column name1> <data type>,
    <column name2> <data type>,
    ...
);

Example: 
     CREATE TABLE Wings
         ( 
             WingID uuid primary key, 
             WingName VARCHAR(100), 
             IsActive boolean 
        );

No comments:

Post a Comment