I discuss following step to step to create database table as:
1. First open SQL Server Management Studio .
2. Select Database name and click on New Query then select database name appear in dropdown that is shown in picture below.
3. If you not selected database then write command to use database that's syntax here is:
use <Database name>
then press F5 to execute command or in tool bar have button execute to click for execute.
4. Then, write query to create database table . Syntax is below
Create table <tablename> (<column name> <data type> <datatype Value>,etc.... )
If you use data type int, bigint then you not give data type value because it is automatically set the range but you have use data type char, varchar then we must give this value like that varchar(50).
5. Then press F5 keyword to execute query then you have create your table successfully.
1. First open SQL Server Management Studio .
2. Select Database name and click on New Query then select database name appear in dropdown that is shown in picture below.
3. If you not selected database then write command to use database that's syntax here is:
use <Database name>
then press F5 to execute command or in tool bar have button execute to click for execute.
4. Then, write query to create database table . Syntax is below
Create table <tablename> (<column name> <data type> <datatype Value>,etc.... )
If you use data type int, bigint then you not give data type value because it is automatically set the range but you have use data type char, varchar then we must give this value like that varchar(50).
5. Then press F5 keyword to execute query then you have create your table successfully.
