![]() ![]() USING clause and the FORCE keyword can be used separately or together. The USING clause and the FORCE keyword are both optional neither are required to set a masking policy on a column. Table without first increasing the precision. If the precision of a column is decreased below the maximum precision of any column data retained in Time Travel, you cannot restore the Increase the precision of the specified number column.ĭecrease the precision of the specified number column if the new precision is sufficient to holdįor text data types, TYPE can be used only to increase the length of the column. type) must beįor the NUMBER data type, TYPE can be used to: When setting the TYPE for a column, the specified type (i.e. The default value for rows inserted after the column was added.ĭropping the default column value from any clone of the table is also prohibited. If the default were dropped, then the column would contain:Ī NULL value for rows inserted before the column was added. Rows inserted after the column was added. ![]() This restriction prevents inconsistency between values in rows inserted before the column was added and ĬREATE TABLE t ( x INT ) INSERT INTO t VALUES ( 1 ), ( 2 ), ( 3 ) ALTER TABLE t ADD COLUMN y INT DEFAULT 100 INSERT INTO t ( x ) VALUES ( 4 ), ( 5 ), ( 6 ) ALTER TABLE t ALTER COLUMN y DROP DEFAULT ALTER TABLE COLUMN UNSET TAG, COLUMN UNSET TAG. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |