<div>
I suggest that you look up the &quot;generate script&quot; in the &quot;all tasks&quot; menu of the table(s).<br />
Cheers
</div>


I suggest that you look up the "generate script" in the "all tasks" menu of the table(s).
Cheers

<div>
see if this helps<br />
create table t1(select * from mytable where 1=2)<br />
t1- is the new table<br />
mytable-is the table who's copy u want<br />
this will copy the structure alone without any data
</div>


see if this helps
create table t1(select * from mytable where 1=2)
t1- is the new table
mytable-is the table who's copy u want
this will copy the structure alone without any data

<div>
thanks for all your input but unfortunatly it wont produce any dynamic output. &nbsp;the script is static to my database. &nbsp;I need something dynamic that will take a table I tell it to and make another table with the same table structure and permissions.
</div>


thanks for all your input but unfortunatly it wont produce any dynamic output.  the script is static to my database.  I need something dynamic that will take a table I tell it to and make another table with the same table structure and permissions.

<div>
i ended up using this, and not needing the user definitions. thanks
</div>


i ended up using this, and not needing the user definitions. thanks

<div>
<div class="content wysiwyg-content">
I need a sql statement that copies a table with all related stuff EXACLTY, but without the data to a new table name. &nbsp;I has to work in sql server 7 and 2000 and must bring permissions and preferably indexes, defaults, etc with it.<br />
<br />
Thanks in advance.
</div>
</div>


I need a sql statement that copies a table with all related stuff EXACLTY, but without the data to a new table name.  I has to work in sql server 7 and 2000 and must bring permissions and preferably indexes, defaults, etc with it.

Thanks in advance.

copy table definition

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.