What are Sql Table Rules and Sql Table Syntax ?

Table Rules 

1) A Table name must be unique under the database.

2) A Table can have maximum of 1024 coulmns.

3) A TABLE Name or COLUMN Name can be having maximum 1 to 128 characters.

4) A TABLE Name or COLUMN Name do not start with special characters and numerics.should be start with alphabates.

Syntax Of Table

CREATE TABLE <TableName>(<columnName><datatype>[(<size>)][.....n]
Example
Employee:  EmpNo,EmpName,EmpJob,EmpSalary,EmpDateOfJoin,EmpStatus

CREATE TABLE Employee(EmpNo int,EmpName Varchar(50),Job Varchar(50),EmpSalary Decimal(9,2),EmpDateOfjoin Date,EmpStatus Bit)
About Author: author 4 + years of Information Technology experience in understanding and analyzing the software and hardware engineering requirements, onsite and offshore management of product development. Expert work on design and development for windows,web,mobile Expert knowledge of C#,ADO.NET, ASP.Net MVC, ENTITY FRAMEWORK, LINQ,COLLECTIONS, JAVASCRIPT,AngularJs 1.0,Angular2, Jquery,Jquery-Ajax, SQL SERVER, XAML,Windows phone 8.1 Good knowledge of WCF-Restful services,WCF, WEB API-Services ,Web- Services,MIcrosoft-Azure,JUICE UI,HTML,CSS,AJAX Read More...

Join him on Google+ | Facebook | Linkedin

No comments