Skip to main content

Posts

Showing posts with the label Syntax to drop object in sql

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.