In the below example we can see that we have added column name as new_date and defined datatype as date. At the time of adding new column into the table, the new column is added at the last position from all the columns.īelow example shows that while adding new column into the table in redshift it will added at last position. We can define null or not null constraint to the column at the time of adding into the table. We can also define the constraint to the column at the time of adding. As per data we are defining datatype for the column. We can define size of the column as per the data that we are inserting into the column.Īt the time of adding new column to the table, we are using below data type for the new column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |