Ejemplos de PrepareEnv.SchemaProvider TableRef en C# (CSharp)

Ejemplo n.º 1

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

Ejemplo n.º 2

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

Ejemplo n.º 3

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

Ejemplo n.º 4

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