<div>
Try this:<br />
<br />
SELECT * <br />
INTO NWDEBTP_DROP_V600 <br />
FROM NWDEBTP<br />
<br />
TRUNCATE TABLE NWDEBTP
</div>


Try this:

SELECT *
INTO NWDEBTP_DROP_V600
FROM NWDEBTP

TRUNCATE TABLE NWDEBTP

<div>
SELECT * INTO NWDEBTP_DROP_V600 FROM nwdebtp<br />
TRUNCATE TABLE nwdebtp
</div>


SELECT * INTO NWDEBTP_DROP_V600 FROM nwdebtp
TRUNCATE TABLE nwdebtp

<div>
BUT I STILL NEED TO CREATE TABLE &nbsp;NWDEBTP_DROP_V600 AS NWDEBTP TABLE THAT EXIST IN THE DATABASE HOW DO I DO THAT
</div>


BUT I STILL NEED TO CREATE TABLE  NWDEBTP_DROP_V600 AS NWDEBTP TABLE THAT EXIST IN THE DATABASE HOW DO I DO THAT

<div>
 NWDEBTP_DROP_V600 is created automatically by SELECT INTO command
</div>


NWDEBTP_DROP_V600 is created automatically by SELECT INTO command

<div>
SELECT INTO copies the data and the schema. &nbsp;I'm not sure about any indexes or constraints...could someone confirm or deny this?
</div>


SELECT INTO copies the data and the schema.  I'm not sure about any indexes or constraints...could someone confirm or deny this?

<div>
Just data, no indexes or constraints. The only one special copied information is identity column.
</div>


Just data, no indexes or constraints. The only one special copied information is identity column.

<div>
If you just need to change the name of the table, use sp_rename system procedure:<br />
<br />
sp_rename 'NWDEBTP','NWDEBTP_DROP_V6<wbr />00'
</div>


If you just need to change the name of the table, use sp_rename system procedure:

sp_rename 'NWDEBTP','NWDEBTP_DROP_V600'

<div>
<div class="content wysiwyg-content">
Could you please rewrite the oracle script below in sql script<br />
<br />
i want to remane the nwdebtp table as NWDEBTP_DROP_V600 and then select all data in nwdebtp &nbsp;into NWDEBTP_DROP_V600 table and truncate the nwdebtp. the nwdebtp is already exist in the sql &nbsp;2000 database<br />
<br />
CREATE TABLE NWDEBTP_DROP_V600 AS SELECT * FROM NWDEBTP<br />
<br />
TRUNCATE TABLE NWDEBTP
</div>
</div>


Could you please rewrite the oracle script below in sql script

i want to remane the nwdebtp table as NWDEBTP_DROP_V600 and then select all data in nwdebtp  into NWDEBTP_DROP_V600 table and truncate the nwdebtp. the nwdebtp is already exist in the sql  2000 database

CREATE TABLE NWDEBTP_DROP_V600 AS SELECT * FROM NWDEBTP

TRUNCATE TABLE NWDEBTP

sql tABLE

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.