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
- 7051 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 |
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
What are filegroups in sql server?
Explain nested trigger in sql?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is split brain scenario in DB mirroring?
What is awe?
How is table type constraint applied to a table?
What do you understand by recursive stored procedures?
syntax for deleting the database in T SQL
What is normalization? What number of normalization shapes are there?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are “lost updates”?
-
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)
