Saturday, March 11, 2023

Create Table Using MSSQL SERVER

  • Click On Database Folder and Expand.
  • Right Click on Tables Folder.





  • Move 'New' and Click on Table



  • Display Table Design View
  • Enter Column Names and Select Data Type which you need.



  • Right Click on Column which you wish to selected as  Primary Key and Click on 'Primary Key'.



  • Click On 'Save' Button.



  • Give the name which you need for Table and Click 'Ok'






Now you Can See table in table Folder which you created.


No comments:

Post a Comment

SQL INSERT QUERY

This Command use for Insert New Record in to Table . INSERT INTO Syntax. INSERT INTO  < Table name > ( Table Column names ) values (...