How to know this clarification for this concept

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

Kumaraspcode2009@gmail.com