» SQL Data Definition
SQL Data Definition
Table is a basic element of relational database and create table is very important before you are working with data which you want to store.
with SQL ALTER TABLE statement you can add, drop one or more columns from a table.
DROP TABLE statement allows you drop an existing table in database which is useful in some programming situations.
SQL View is a virtual table which is used to encapsulate a complex queries.Click here to see how to create SQL view
SQL view is a virual table so it can be changed using ALTER VIEW statement.
SQL DROP VIEW statement removes view definition from the system catalog and the dependent objects of that view will become invalid.
A database index is similar to the book's index which helps you to find a topic faster by looking up on it.
SQL DROP INDEX statement frees allocated memory and removes the index definition from the database information schema