0
Describe drop table commands of sql with both the options cascade and restrict?
Wiki User
∙ 16y ago
A table can have object dependencies. Indexes, views, programs. When you give a "drop table" command, it will not drop the table that has dependencies unless you include the "cascade" command in the statement. The database programming is written this way to make sure you know the table has dependent objects and makes you explicitly say you want to drop the table and all its dependencies. You should be very careful with this command. If you find you need to restore this table, you'd also have to recreate the view and index and recompile the programs attached. The best way to recover from this is if you have a tool that will put the create statement into a file, including all attached objects. That way, if you drop the table and need to recover, all you have to do is run the create command which will recreate in a minute versus a recovery that could take 30 minutes to hours dependent upon the availability of the data. After you run the create statement, make sure all objects are attached, test the view and make sure the programs are VALID.
Wiki User
∙ 16y ago
Add your answer:
Earn +20 pts
Describe two ways of issuing a command in medisoft?
Commands are issued by clicking options on the menu bar or by clicking shortcut buttons on the toolbar.
Which of these options help you manage multiple windows on your desktop?
Cascade
Commands how can you display the options given for it?
-l
How do you put a blackberry bold to private number?
Go to Settings > Options > Phone options > General Options > Restrict my identity
You want to restrict administrator to change ip address of own PC?
You cannot restrict Admistrators type users to change options.
What to use to initiate commands in Office programs?
You can activate options for commands by pressing the Alt key or the F10 key.
Which software contains lists of commands and options?
Minu bar
What can you use when the paste options button is visible to access the paste commands available in the paste options?
Click on the button with the mouse and it will open out the options for you.
What do options command and the office button menu do?
Open a menu of commands.
What are the controls 2 mugen?
Go to options>input commands>p1.
What option is used for the windows 'ping' command to continue until stopped?
The option is "-t".Type ping /? to get a list of options. The same parameters, /?, is used for many other commands, too.The option is "-t".Type ping /? to get a list of options. The same parameters, /?, is used for many other commands, too.The option is "-t".Type ping /? to get a list of options. The same parameters, /?, is used for many other commands, too.The option is "-t".Type ping /? to get a list of options. The same parameters, /?, is used for many other commands, too.
How do you describe a Greek tragedy?
No options are given
