Is there any syntax when i create table from another table
I would like to add some primary key while creating table from selecting from another database synonym.
Ex:
CREATE TABLE new_table UC_NUMB
AS (SELECT UC_NUMB FROM Testanotherdb.Testsynonym);
I want to make UC_NUMB as primary or unique key in one statement, not with 2 statements like create and alter.
Thanks