Posted by David Portas on 09/09/05 18:58

CREATE TABLE newtable (col1 INTEGER, col2 ... etc ... , CONSTRAINT
pk_newtable PRIMARY KEY (col1, col2)) ;

INSERT INTO newtable (col1, col2, ...)
SELECT col1, col2, ...
FROM oldtable ;

Also, take a look at the ALTER TABLE ... ADD CONSTRAINT syntax in Books
Online.

--
David Portas
SQL Server MVP
--

• Next in forum: Re: table copy misses indexes
• Prev in forum: table copy misses indexes
• Thread view: Re: table copy misses indexes

[Reply to this message]