Copy table from one db to another db without copying data 1

[emilyng]

Can I know how to copy a blank table (with fields) from one database (with data in the table) to another database without copying the data?
I am currently running SQL 7 (desktop version)

 

[sguslan]

try ..

select * into db2.dbo.newtablename from db1.dbo.oldtablename
where 1=0

note that db1 and db2 are the database names such as the northwind database that ships with sql server.

 

[JayKusch]

Script the table out to a text file. open query analyzer on the machine you want to create the empty "New" table and copy in the script and run. will create the table w/ no data

 

[emilyng]

thanks folks!