psGDropCheckConstraints

Description

     From a list of tables in a segment map, psGDropCheckConstraints creates a
a SQL script to drop all check constraints on those tables.  The SQL will contain
dynamical SQL, which in turn, reads the database's system tables for the names of the
constraints.

 

Syntax

psGDropCheckConstraints -Tsegment_map_file -Fnew_sql_file
-Nschema_name -Ooptions

 

Arguments

-T

Segment Map File

-F

Output SQL Script [standard output]

-N

Script Name (optional)

-O

Options

 

Options

s

Sybase

o

Oracle

m

Microsoft SQL Server

i

Informix

r

Postgres

y

MySQL

g

ODBC

p

Stop at the first parsing problem

 

Environment Variables Behind the Scenes

PS_SYSMSG_FILE

Name of DBPowerSuite's messages file.

 

Go to DBPowerSuite 7.9 List of Programs.


Updated: Thu Jun 18 21:12:26 2009