December 7, 2013

Create,Delete database,table,table data,index in sql by query analyzer

Delete database,table,table data,index in sql by query analyzer

1. To delete all data from table .
TRUNCATE TABLE tablename

2. Delete database through query analyzer
DROP DATABASE databasename

3. Delete table in sql
DROP TABLE tablename

4. Delete index from table in sql.
DROP INDEX tablename.indexname

To create database in sql you can use following command in sql query analyzer.

Create Database in SQL

CREATE DATABASE databaseName;

Second way is you can right click by mouse and select create new database then set name of database in sql prompt.