Disabling and Enabling of a Table
21K views
Oct 24, 2024
Disabling and Enabling of a Table
View Video Transcript
0:00
In this video we are discussing disabling and enabling of a table in edge base
0:07
So, table, what is table disabling? So to delete a table or change its settings, you need to first disable the table using
0:17
the disable command. So before going for the deletion or before going for change in the settings of the edge
0:24
base table at first we should make the table disable. So the command will be
0:30
table name. So, syntax of the command will be disabled table name. Here, disable is the
0:35
command here. So, when the table is disabled, we cannot scan it or we cannot insert some data
0:40
onto it. We cannot get the content of the data. We cannot perform any insert operation of a new
0:45
data onto the table is prohibited. So to check whether a table is disabled or not, we can
0:52
use the command that is e. Is underscore disabled command. So syntax will be ease underscore disabled
0:58
and the table name. Now it will give us the idea, give us the output whether the table has
1:03
got disabled or not. What is table enabling? When a table is already disabled, we can enable
1:12
it by using the enable command. So, syntax will be enable table name. So to check whether
1:19
a table is enabled or not, we can use the command that is e. underscore enabled command. So
1:25
syntax will be e is underscore enabled and then the table name in this way it will give us
1:31
the idea that whether the table has got enabled or not so let us go for one practical
1:36
demonstration for the easy understanding of this concept in this demonstration we
1:42
shall show you that how to do the disabling and enabling the tables in our age base
1:48
that means how to make the table disable and how to make the table enable here so to disable the table that is a table a student table we are going to issue the command that is a disabled student
2:01
so we are going for the disabled student so the command is disabled student so the command is
2:10
disabled student so if we execute this command you can find that it has got
2:16
executed successfully we can check you can go for is disabled student
2:27
you can find that it is giving you true so if you go for is enable student I'm
2:38
getting the answer here false okay so now in this disable mode if we want to go for scan student if you go for
2:48
the scan student you see the scanning is not being done because the table is in the
2:54
disable mode so that's why I cannot do the scanning I cannot see the content
2:59
of this table so that is the scan whatever we have executed here now we shall go
3:06
for the enabling of the student so the command will be enabled So the command is enabled
3:15
Then if you go for the scan, you can get the content
3:24
You can go for is enabled. So that is the true. If you go for is disabled, the condition will be false
3:36
And in this way, in this particular demonstration we have shown you how to do you
3:40
do enable and disable of a table whichever which we have created earlier thanks for
3:46
watching this demonstration
#Programming