How to create Table in SQL Server

Execute below query

Syntax :
use Database_Name
go
Create Table Table_Name
(
   Column_Name Data_Type(Data_Length) Null/Not Null Key_Constraint(Optional),
   Column_Name Data_Type(Data_Length) Null/Not Null Key_Constraint(Optional),
   Column_Name Data_Type(Data_Length) Null/Not Null Key_Constraint(Optional),
   ...
   ...
   ...
   Column_Name Data_Type(Data_Length) Null/Not Null Key_Constraint(Optional)
)

Example:
use test
go
Create Table tblPersonInfo
(
   ID int NOT NULL Primary Key,
   Name nvarchar(50) NOT Null,
   Email nvarchar(50) Null
)

Note :
1. use Database_Name
    go
--this command is used to enforce the SQL Server to create table in the appropriate database (Optional command) supply that database name in which you want to create table
2. Create Table Table_Name
-- Here you have to provide meaning full Table name
3.  Column_Name Data_Type(Data_Length) Null/Not Null Key_Constraint(Optional)
-- Column_Name - here you have to supply meaning full column name
-- Data_Type(Data_Length) - supply valid data type as per your column's requirement, Data type could be INT, VARCHAR, NVARCHAR etc. and length of data type depend upon column
-- Null/Not Null - choose either NULL or NOT NULL. it's depend on database designer whether he want to enforce user to supply data or not in that column.
4. Key_Constraint(Optional)
-- there should be only one Primary Key reside in a particular table 
-- It could be Primary Key that maintain database integrity, means in which column you define Primary Key that column accept only unique data on that particular column

How to create Database in SQL server

Execute below SQL query
Syntax : Create Database database_Name
Example : Create Database Test

Note: In the example Test is the name of database(You can choose any meaning full name). it will create an empty database in the SQL Server.

How to reset Identity column in SQL Server

Execute Below query

DBCC ( 'tableName',RESEED,0)

Note : DBCC stands for Database Consistency Check. it is a system define function to RESEED the Identity Column in the supplied table.

How to drop a column from table

Execute below query to get desire result

Alter Table 'table_name'

Drop Column 'Column_Name' 

How to select random row from MySQL Database

1. Select top 1 * from 'table_name' order by NEWID()
    Above query return 1 row on the random basic.. row might be repeat .

2. Select top 1 * from 'table_name' where Id=(select (RAND()*Count(Id)) from 'table_name')
    Above query return 1 row from total rows present in table on random basic .. row might be repeat .
    note : Id is the Column name and Id must be in sequence and unique

3. Select top 1 * from 'table_name' where Id=(select Floor(RAND()*Count(Id)) from 'table_name')
    Frequency of repeat row might be less