DROP TYPE(7) SQL Commands DROP TYPE(7)NAME
DROP TYPE - remove a user-defined data type
SYNOPSIS
DROP TYPE typename [, ...] [ CASCADE | RESTRICT ]
INPUTS
typename
The name (optionally schema-qualified) of an existing type.
CASCADE
Automatically drop objects that depend on the type (such as table columns, functions, operators, etc).
RESTRICT
Refuse to drop the type if there are any dependent objects. This is the default.
OUTPUTS
DROP TYPE
The message returned if the command is successful.
ERROR: RemoveType: type 'typename' does not exist
This message occurs if the specified type is not found.
DESCRIPTION
DROP TYPE will remove a user type from the system catalogs.
Only the owner of a type can remove it.
EXAMPLES
To remove the box type:
DROP TYPE box;
COMPATIBILITY
Note that the CREATE TYPE command and the data type extension mechanisms in PostgreSQL differ from SQL99.
SEE ALSO
CREATE TYPE [create_type(7)]
SQL - Language Statements 2002-11-22 DROP TYPE(7)
Check Out this Related Man Page
DROP INDEX(7) SQL Commands DROP INDEX(7)NAME
DROP INDEX - remove an index
SYNOPSIS
DROP INDEX index_name [, ...] [ CASCADE | RESTRICT ]
INPUTS
index_name
The name (optionally schema-qualified) of an index to remove.
CASCADE
Automatically drop objects that depend on the index.
RESTRICT
Refuse to drop the index if there are any dependent objects. This is the default.
OUTPUTS
DROP INDEX
The message returned if the command completes successfully.
ERROR: index "index_name" does not exist
This message occurs if index_name is not an index in the database.
DESCRIPTION
DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.
NOTES
DROP INDEX is a PostgreSQL language extension.
Refer to CREATE INDEX [create_index(7)] for information on how to create indexes.
USAGE
This command will remove the title_idx index:
DROP INDEX title_idx;
COMPATIBILITY
SQL92
SQL92 defines commands by which to access a generic relational database. Indexes are an implementation-dependent feature and hence there
are no index-specific commands or definitions in the SQL92 language.
SQL - Language Statements 2002-11-22 DROP INDEX(7)
Hi,
I have a sql file that runs something like this
vi Test.sql
REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM PUBLIC;
REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM DEMO_READ;
REVOKE SELECT ON DEMO_USER.DEMO_NOMINEE_TEST FROM DEMO_READ;
REVOKE EXECUTE ON DEMO_USER.SQC_SAMP FROM... (3 Replies)
Hi All,
Please let me know what i am missing in the following code (part of my script)
Schemas=(AWQM WFCONTROLLER PROVCO PRISM)
for s in "${Schemas}"
do
sch="${s}_$tol"
if || ;then
echo "This is AD or TD region"
sqlplus -s $sch/$tpwd@$ttns <<EOF... (7 Replies)