Prado\Data\Common\Mssql\TMssqlMetaData::findTableNames PHP 메소드

    public function findTableNames($schema = 'dbo')
    {
        $condition = "TABLE_TYPE='BASE TABLE'";
        $sql = <<<EOD
SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES]
WHERE TABLE_SCHEMA=:schema AND {$condition}
EOD;
        $command = $this->getDbConnection()->createCommand($sql);
        $command->bindParam(":schema", $schema);
        $rows = $command->queryAll();
        $names = array();
        foreach ($rows as $row) {
            if ($schema == self::DEFAULT_SCHEMA) {
                $names[] = $row['TABLE_NAME'];
            } else {
                $names[] = $schema . '.' . $row['TABLE_SCHEMA'] . '.' . $row['TABLE_NAME'];
            }
        }
        return $names;
    }