85
T-SQL Drop-Table
The DROP TABLE statement in T-SQL is used to remove the table definition and remove the data, indexes, triggers, constraints of the table.
Note- We need to use this command carefully because if we delete a table by using this command then all the data stored in the table will be lost forever.
Syntax of Drop-Table
The syntax of the DROP TABLE statement is-
Example:
Firstly, verify the CUSTOMERS table, and then delete it from the database-
The above command generates the following table.
TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME PRECISION LENGTH SCALE RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SS_DATA_TYPE TestDB dbo CUSTOMERS ID 4 int 10 4 0 10 0 NULL NULL 4 NULL NULL 1 NO 56 TestDB dbo CUSTOMERS NAME 12 varchar 20 20 NULL NULL0 NULL NULL 12 NULL 20 2 NO 39 TestDB dbo CUSTOMERS AGE 4 int 10 4 0 10 0 NULL NULL 4 NULL NULL 3 NO 56 TestDB dbo CUSTOMERS ADDRESS 1 char 25 25 NULL NULL 1 NULL NULL 1 NULL 25 4 YES 39 TestDB dbo CUSTOMERS SALARY 3 decimal 18 20 2 10 1 NULL NULL 3 NULL NULL 5 YES 106
CUSTOMERS table is available in the database, so let’s drop it. Below is the command:
Command (s) completed.
With the above command, we have not received any row.
No any data is displayed here as table is deleted.
We will explain the Create Statement in T-SQL in the next page.
Next TopicT-SQL INSERT STATEMENT