Copy the structure of a table without copying the data in SQL

Question

How will you copy the structure of a table without copying the data in SQL?

Shankar M · Answer

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-fareast-font-family:"Times New Roman";mso-fareast-theme-font:minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} In Oracle: CREATE TABLE TABLE_X AS SELECT * FROM table_y WHERE 1=0; Thanks, Shankar

Vulpes · Answer

There's a little hack you can use to easily do this: SELECT * INTO newTable FROM oldTable WHERE 0 = 1 As the WHERE clause always returns false, no records are copied just the structure : )

Satyapriya Nayak · Answer

SELECT TOP 0 * INTO newtable FROM oldtable SELECT TOP 0 * INTO employee1 FROM employee

Copy the structure of a table without copying the data in SQL

Answers (3)