Learn SQL Commands (Part-2)

Mohammed Waseem
3 min readSep 29, 2022

T-SQL Commands for everyone

Table Of Contents

  1. Create a table that doesn't allow empty values
  2. Create a table with limiting conditions
  3. Create a table with specific conditions
  4. Modify data on a table
  5. Delete data(row) from a table
  6. Delete a table
  7. Delete a database
  8. Modify the data type of a table
  9. Modify Column Name of a table
  10. Add a new column to an existing table
  11. Remove column from an existing table
  12. Rename a table name

1. Create a table that doesn’t allow empty values

2. Create a table with limiting conditions

3. Create a table with specific conditions

4. Modify data on a table

(Before Update)

(After update)

5. Delete data(row) from a table

6. Delete a table

7. Delete a database

8. Modify the data type of a table

9. Modify Column Name of a table

10. Add a new column to an existing table

11. Remove column from an existing table

12. Rename a table name

Part 3 Coming Soon…….

--

--