Rename Table in SQL Server Hi friends, in this post we will learn to Rename Table in SQL Server. Renaming a table in SQL server sometimes required as we do require same columns and data, with a different name. We can not use ALTER statement to rename table in SQL server. Earlier we had discussed […]
Author: Mandeep Singh
Categories
Create Table SQL Server
Create Table SQL Server Hi friends, in this post we will learn to Create Table SQL Server. Creating table in SQL Server is very easy. Tables consist rows and columns, columns name specify the name of columns and rows contains data in them. Column has data_type parameter which specifies what type of data the column can hold […]
Categories
Schema In SQL Server
Schema In SQL Server What is schema? Hi friends, in this post we will learn about Schema in SQL Server. A schema is a container that holds tables, views, procedures, and so on. It is inside a database. The server is the outermost box, and the schema is the innermost box. In earlier post we […]
Categories
SQL Server Operators
SQL Server Operators Hi friends, in this post we will discuss about SQL Server Operators. Operator is a symbol specifying an action performed on one or more expressions. Operators are used to specify conditions in an SQL statement. Following are operators in SQL Server: Arithmetic Operators: Arithmetic operators used to perform mathematical operations on two expressions. Operator […]