Interested to Buy Any Domain ? << Click Here >> for more details...
How create table structure only from tableA to TableB if
TableA have some data?
- 4 Answers
- 6845 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunny
to copy only the structure
select * into table2 from table1 where 1=2
to copy the table along with the records
select * into table2 from table1 where 1=1
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / karthik
Create table emp1
as
select * from emp
where 1=2
It will give the structure of the table.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / mits
Create table newtablename
from oldtablename
where 1=2
| Is This Answer Correct ? | 4 Yes | 6 No |
Do you know what is sql injection?
How to assign null values to variables or columns?
syntax for deleting the database in T SQL
Define views.
Why we use functions in sql server?
Is it possible in sql table to have more than one foreign key?
What command is used to delete a table from the database in the sql server and how?
What are statistics, under what circumstances they go out of date, how do you update them?
What are approximate numeric data types in ms sql server?
What are the differences between clustered and non-clustered index?
What is log cache in sql server?
Why de-normalization required?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
