MS Code Tech

Monday, March 2, 2015

To delete a table using SQL, use the following formula:

DROP TABLE TableName

Ex.

DROP TABLE dbo.StaffData

Posted by Unknown at 4:59 AM

Create SQL Table

start here learn sql database. Create Data Table: CREATE TABLE Employee( Column1 , Column2 , Column3 ) Ex. Create Employee Data Table,...
Primary Key

Table Create With Primary Key And Auto increment id CREATE TABLE [dbo].[New_User] ( U_id int identity(1,1) Primary Key , U_Nam...
Renaming a Table

Sql Table Rename Query, sp_rename ExistingTableName , New TableName Ex. sp_rename EmployeeData, StaffData Now see your database li...
Drop Table

To delete a table using SQL , use the following formula: DROP TABLE TableName Ex. DROP TABLE dbo.StaffData

Rakesh Chavda. Watermark theme. Powered by Blogger.

Watermark theme. Powered by Blogger.