search

minhphien / migratordotnet

Automatically exported from code.google.com/p/migratordotnet
0 stars 0 forks source link

Drop Table Schema Problem #73

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Drop table cant drop tables if it has got a schema name. 
When i want drop a table like : 

Database.RemoveTable("Hodo.MigrationDotNet_Hede");

your check sql is look like : 

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_NAME='Hodo.MigrationDotNet_Hede'

and TableCheckExsist returns false. It must be

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_NAME='MigrationDotNet_Hede' AND TABLE_SCHEMA = 'Hodo'

Original issue reported on code.google.com by oguz.kur...@gmail.com on 13 Oct 2008 at 8:57

GoogleCodeExporter commented 9 years ago 
Issue #45

Original comment by geoffl...@gmail.com on 9 Feb 2009 at 11:12