CREATE TABLE test AS SELECT * FROM existing_table;
I got an error from MS-SQL and then I had to call up some experts on MS-SQL to understand how it is done in MS-SQL.
The syntax for creating such a duplicate table of an existing one in MS-SQL is as follows:
Thus our example can be translated to as:
This short article is to just keep up the difference between MS-SQL and Oracle. Oracle professionals may sometimes need to work in MS-SQL, and this kind of tips on MS-SQL comes handy in times of trouble.