SQL Query to Copy Structure and Data of One table To Other in SQLServer

How to copy structure and data of one table into another table?

Syntax: Select * into Newtable from Oldtable

Ex: select * into emp1 from emp

SQL Query to copy only structure of one table to other table in SqlServer
SQL Query to get structure of table in SqlServer

Movie Songs Lyrics
Software Testing-QTP Scripts,Testing Faqs

How to Copy Structure of One Table into Another Table?

SQL Query to copy structure of one table to another table in SQL Server.

Syntax: Select * into Newtable from Oldtable where 1=2

Ex: Select * into emp1 from emp where 1=2

The above query copies only structure(not data) of emp to emp1.

SQL Query to get structure of table

How To Get Structure of a Table in SQL Server?

SQL Query to view structure of a table in sqlserver.

SP_help tablename

SP_help emp

SQL Query to find total number of rows in a table

Query to get number of rows in a table.

select count(*) from tablename

ex:select count(*) as Count from emp

Output

Count
10

SQL Server Faqs
Movie Songs Lyrics
SOftware Testing -QTP Scripts,Testing Faqs