Third, add table constraints if applicable e.g., primary key, foreign key, check.A column definition includes the column name followed by its data type e.g., NUMBER, VARCHAR2, and a column constraint such as NOT NULL, primary key, check. In case a table has multiple columns, you need to separate them by commas (,). Second, list all columns of the table within the parentheses.First, specify the table name and schema name to which the new table belongs on the CREATE TABLE clause. ![]() ![]() ![]() ) Code language: SQL (Structured Query Language) ( sql )
0 Comments
Leave a Reply. |