C# (CSharp) PrepareEnv.SchemaProvider TableRef Examples

Example #1

 private void DropView(TableRef viewName)
 {
     ExecuteNonQuery(String.Format("DROP VIEW {0}",
                                   FormatSchemaName(viewName)));
 }

Example #2

 private void DropFKConstraint(TableRef tblName, string constraintName)
 {
     ExecuteNonQuery(String.Format("ALTER TABLE {0} DROP CONSTRAINT {1}",
                                   FormatSchemaName(tblName),
                                   QuoteIdentifier(constraintName)));
 }

Example #3

 private void DropTable(TableRef tblName)
 {
     ExecuteNonQuery(String.Format("DROP TABLE {0}", FormatSchemaName(tblName)));
 }

Example #4

 private void DropViewCascade(TableRef tblName)
 {
     ExecuteNonQuery(String.Format("DROP VIEW {0} CASCADE", FormatSchemaName(tblName)));
 }