DBPowerSuite 7.9 Application Programming Interface
Generic Database

 

Class Description

Microsoft SQLServer Table

Class Name

DBMSSQLServerTable

Parent Class

DBTable

Header Name

DBMSSQLServerTable.h

Library

libpsDB

Language

C++

Author

Brian N. Ceccarelli

Location

Apex, NC

Date Written

July 31, 2003

Last Updated

July 31, 2003

Last Updated By

Brian Ceccarelli

Notes

     The specific methods of this child class produce SQL code
specifically for Microsoft SQL Server.

See Also

DBTable DBOracleTable DBSybaseTable

 

Public Methods of Class DBMSSQLServerTable

#

Inline

Pure Virtual

Virtual

Method

Description

1

No

No

No

DBMSSQLServerTable()

Constructor

2

No

No

Yes

ps_int32 dbtGenerateAddRI(std::ofstream* f)

Generate SQL To Add RI Constraints

3

No

No

Yes

ps_int32 dbtGenerateAddRules(std::ofstream* f)

Generate SQL To Add Check Constraints

4

No

No

Yes

ps_int32 dbtGenerateCheckRI(std::ofstream* f)

Generate SQL To Check RI Constraints

5

No

No

Yes

ps_int32 dbtGenerateCheckRules(std::ofstream* f)

Generate SQL To Check Rules Check

6

No

No

Yes

ps_int32 dbtGenerateCreateTable(std::ofstream* f)

Generate Create Table SQL

7

No

No

Yes

ps_int32 dbtGenerateDeleteRIViolators(std::ofstream* f)

Generate SQL To Delete Rows Which Violate RI Constraints

8

No

No

Yes

ps_int32 dbtGenerateDeleteRuleViolators(std::ofstream* f)

Generate SQL To Delete Rows That Violate the Table's Check Constraints

9

No

No

Yes

ps_int32 dbtGenerateDropAll(std::ofstream* f)

Drop All Objects Associated with the Table

10

No

No

Yes

ps_int32 dbtGenerateDropRI(std::ofstream* f)

Generate SQL To Drop RI Constraints

11

No

No

Yes

ps_int32 dbtGenerateDropRules(std::ofstream* f)

Generate SQL To Drop Check Constraints

12

No

No

Yes

ps_int32 dbtGenerateStoredProcedures(std::ofstream* f)

Generate Stored Procedures

13

No

No

No

~DBMSSQLServerTable()

Destructor

 

Protected Methods of Class DBMSSQLServerTable

#

Inline

Pure Virtual

Virtual

Method

Description

1

No

No

Yes

ps_int32 dbtWriteEpilogue(std::ofstream* f)

Write the SQL Code Epilogue

2

No

No

Yes

ps_int32 dbtWritePreamble(std::ofstream* f, const ps_char* comment)

Write the SQL Code Preamble

 

Private Methods of Class DBMSSQLServerTable

#

Inline

Pure Virtual

Virtual

Method

Description

 

Go to DBPowerSuite 7.9 Application Programming Interface.


Updated: Thu Jun 18 21:13:23 2009