How would I go about creating a table from another table using Enterprise Manager? My get-my-feet-wet assignment is to create table tblSetHistory from table tblSet, structure only, then create a trigger to insert a tblSet row into tblSetHistory when the WFState column in this tblSet row is updated. I'm stuck on the first part of this assignment.

I right-clicked "Console Root - Microsoft SQL Servers - (local) (Windows NT) - Databases - smallcha - Tables -tblSet". This shows "New Table..., Design Table, Open Table, All Tasks, Cut, Copy, Delete, Rename, Properties, Help". Then I thought I should be able to right-click "Tables", left-click "Paste", then rename the copy of tblSet, but right-clicking "Tables" doesn't show "Paste" - it only shows "New Table..., All Tasks, View, New Window from Here, Refresh, Export List, Help".

I even tried left-clicking "New Table", but apparently this is only for starting a table from scratch.

Right-Click the original table. ->All Tasks->Generate SQL Script...
From here you can create a SQL-script that you may run in Analyzer. Just change the name of the table in the script to what you want...

Do you have to do this in Enterprise Manager? To "duplicate" a table's structure to a new table you can just execute this simple query:

SELECT * INTO MyNewTable FROM MyExistingTable WHERE 1=2

This creates MyNewTable with the structure of MyExistingTable but without any data (WHERE 1=2).

or just from QA generate table create script and rename the table name

Ahmed Ali
Software Developer

Thank you, Gert, alyeng2000, and planoie, for all your suggestions. I ended up left-clicking start, enterprise manager, console root - microsoft sql servers - (local) (windows nt) - databases - smallcha, Tools, and SQL Query Analyzer, entering SELECT * INTO tblSetHistory FROM tblSet WHERE 1=2, right-clicked the box, and left-clicking Execute, which gave me my new table.

Now, on to problems with the second part of my assignment, which I will post in "SQL language".