var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: copy a table structure
how can i copy a table structure from a database to another(without bakup)?
Right Click on the table in Enterprise manager go, All Tasks, Generate SQL Script.
Then Click formatting tab, make sure that generate CREATE is the only script generated then...
Options, Script Indexes, Script Triggers, Script PRIMARY Keys, Foreign Keys.. Check on.
Hope this helps.
i think this also might work:
select * into database2.table from database1.table1 where 1=0
i want somethin like this:
that works in mySQL, but in msSQL i got this error msg:
CREATE table mytable_copy AS
SELECT * from originaltable ;
Incorrect syntax near the keyword 'as'.
Last edited by bono56; 10-22-05 at 06:36.
congrats for resurrecting a one year old thread
did you actually try the sql in post #3?