How can you create an empty table from an existing table?
Answer / Aman Saxena
"To create an empty table with the same structure as an existing table in SQL, use the CREATE TABLE AS SELECT * FROM table_name WHERE 0=1 command"
| Is This Answer Correct ? | 0 Yes | 0 No |
Can a foreign key be null?
how to use like conditions? : Sql dba
What is record data type?
What is clustered index sql?
when is the use of update_statistics command? : Sql dba
Why we use join in sql?
What is serial sql?
What is left join in sql?
what does the t-sql command ident_current does? : Transact sql
how can we find the number of rows in a table using mysql? : Sql dba
Explian rowid, rownum? What are the psoducolumns we have?
How do I send sql query results to excel?
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)