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
- 7166 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 |
How to find the date and time of last updated table?
Explain timestamp datatype?
How can u get the number of pupils connecting the database?
How do you identify a foreign key?
Where sql server usernames and passwords are stored in a sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
how to get 25th row in any table in sqlserver can u tell me syntax
What are relationships and mention different types of relationships in the dbms
Can you create a logon trigger in sql server 2005 express edition?
What language is sql server written in?
How to connect php with different port numbers?
-
Oracle (3253) - 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)
