Create table (structure) from existing table

by

Try:

Select * Into <DestinationTableName> From <SourceTableName> Where 1 = 2

Note that this will not copy indexes, keys, etc.

If you want to copy the entire structure, you need to generate a Create Script of the table. You can use that script to create a new table with the same structure. You can then also dump the data into the new table if you need to.

If you are using Enterprise Manager, just right-click the table and select copy to generate a Create Script.

More Related Contents:

  1. Subquery in select not working in SQL Server
  2. How do I get list of all tables in a database using TSQL?
  3. Storing images in SQL Server?
  4. Escape a string in SQL Server so that it is safe to use in LIKE expression
  5. Limitations of SQL Server Express
  6. SQL time difference between two dates result in hh:mm:ss
  7. Storing files in SQL Server
  8. Dynamic SQL (passing table name as parameter)
  9. Dapper.NET and stored proc with multiple result sets
  10. “order by newid()” – how does it work?
  11. T-SQL Dynamic SQL and Temp Tables
  12. Efficient ISNUMERIC() replacements on SQL Server?
  13. How to determine total number of open/active connections in ms sql server 2005
  14. Login to Microsoft SQL Server Error: 18456
  15. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  16. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  17. ORDER BY DATE showing NULLS first then most recent dates
  18. How can I determine in SQL Server if a dateTime range overlaps another
  19. How to split a string after specific character in SQL Server and update this value to specific column
  20. Avoid Naming User Stored Procedures SP% or SP_%
  21. SQL Server Configuration Manager cannot be found
  22. SQL Server Passthrough query as basis for a DAO recordset in Access
  23. T-SQL query to show table definition?
  24. Copy table to a different database on a different SQL Server
  25. Include missing months in Group By query
  26. How to set value to variable using ‘execute’ in t-sql?
  27. Taking the second last row with only one select in SQL Server?
  28. What is the difference between Cartesian product and cross join?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment