How to know this clarification for this concept

Posted by Jayakumars under C# on 3/28/2017 | Points: 10 | Views : 288 | Status : [Member] [MVP] | Replies : 1

What is the Difference Between schema with table vs without schema table.

I am create one table 1. without schema and 2. with schema one table

what is difference between both table and advantages and disadvantages

why we need go to schema with table? any one guide me proper way

create table temp1
Id int,
Empno varchar(20)

create schema temp

create table temp.temp1
Id int,
Empno varchar(20)

Mark as Answer if its helpful to you


Posted by: Jitendrasoft09 on: 6/11/2017 [Member] [MVP] Starter | Points: 25

Schema is just logical definition of of a table and Table is structure with set of records. Go with link for more understanding.

Jitendra Kumar
If my post helps you, plz mark as an answer.

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response