CREATE Statement in SQL

Creating a Database :

    Query: 
   Create database databasename. 

   Example : create database office . 

   How To View All the databases ? 
   Query : SP_HELPDB 

   How To View All the databases Tables ? 
   Query : SP_TABLES 

   What are the datatypes available  ?
   INT , CHAR , VARCHAR , NVARCHAR , FLOAT , LONG , MONEY ....

Creating a Table :

    Creating a Table :

   Query : create table table name (data1 datatype1 ,..........) 
  
   Example : create table empdetails (id int , Name Varchar (20) , Designation Varchar          (20),    Salary int , MobileNo bigint)