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_Name nvarchar(20),

U_Contact nvarchar(15)

)

Table Create With Primary key Constraint 

CREATE TABLE [dbo].[New_User]

(

U_id int constraint PK_User_Id Primary Key,

U_Name varchar(20),

city varchar(20)

)

Drop Table

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

DROP TABLE TableName

Ex.

DROP TABLE dbo.StaffData

Renaming a Table

Sql Table Rename Query,

sp_rename ExistingTableName, NewTableName

Ex.

sp_rename EmployeeData, StaffData

Now see your database list New Rename Table StaffData

Create SQL Table

start here learn sql database.
Create Data Table:

CREATE TABLE Employee(Column1, Column2, Column3)

Ex. Create Employee Data Table,

CREATE TABLE EmployeeData
(
EmployeeId Int,
EmployeeName nvarchar(20),
Address nvarchar(100)
)