A Small Utility to Generate Cascading Delete SQL Script in Oracle

Public Interface IDictionaryInfo

    ''' <summary>
    ''' Get Primary Key of a table 
    ''' </summary>
    ''' <param name="strTableName"></param>
    ''' <returns></returns>
    ''' <remarks></remarks>
    Function GetPKColName(ByVal strTableName As String) As String

    ''' <summary>
    ''' Get foreign key reference table and the foreign key column in that table
    '''   A list of KeyValuePair replaces a dictionary since one reference table may have 1+ reference column. 
    ''' </summary>
    ''' <param name="strTableName"></param>
    ''' <returns></returns>
    ''' <remarks></remarks>
    Function GetFKReferences(ByVal strTableName As String) As List(Of KeyValuePair(Of String, String))


End Interface