-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Learn Java 17 Programming - Second Edition
By :
After the database is created, the following three SQL statements will allow you to create and change the database structure. This is done through database entities, such as a table, function, or constraint:
CREATE statement creates the database entity.ALTER statement changes the database entity.DROP statement deletes the database entity.There are also various SQL statements that allow you to inquire about each database entity. Such statements are database-specific and, typically, they are only used in a database console. For example, in the PostgreSQL console, \d <table> can be used to describe a table, while \dt lists all the tables. Refer to your database documentation for more details.
To create a table, you can execute the following SQL statement:
CREATE TABLE tablename ( column1 type1, column2 type2, ... );
The limitations for a table name, column names, and types of values that can be used depend...