The SQL command for deleting an entire table.
DROP TABLE is used in SQL to remove a table.
Questions tagged [drop-table]
152 questions
-2
votes
2 answers
Drop tables in a database which are created older than two months from current date
I need to drop multiple tables in my DB which got created more than two months from current time.
My database has these sample tables:
Table_A_20200101
Table_B_20200212
Table_C_20200305
Table_Exp
Table_XYZ
harun raseed
- 21
- 2
-2
votes
1 answer
Why is my SQL Server CE table undroppable in Query Analzyer?
I tried dropping a SQL Server CE table using both:
drop invHeader
-and:
drop [invHeader]
...in Query Analyzer, but in both cases, I get the same err msg:
Dropping a table should be drop-dead easy, but this one keeps bouncing back up, like a…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862