How to know this clarification for this concept

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

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


Responses

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

Up
0
Down
Schema is just logical definition of of a table and Table is structure with set of records. Go with link for more understanding.https://stackoverflow.com/questions/298739/what-is-the-difference-between-a-schema-and-a-table-and-a-database


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