• Модуль: main
  • Путь к файлу: ~/bitrix/modules/main/lib/db/mssqldbconnection.php
  • Класс: BitrixMainDBMssqlDbConnection
  • Вызов: MssqlDbConnection::getTableFields
public function getTableFields($tableName)
{
	if (!array_key_exists($tableName, $this->tableColumnsCache))
	{
		$this->tableColumnsCache[$tableName] = array();
		$strSql =
			"SELECT * ".
			"FROM INFORMATION_SCHEMA.COLUMNS ".
			"WHERE TABLE_NAME = '".$this->getSqlHelper()->forSql($tableName)."'";
		$rs = $this->query($strSql);
		while ($ar = $rs->fetch())
		{
			$ar["NAME"] = $ar["COLUMN_NAME"];
			$ar["TYPE"] = $ar["DATA_TYPE"];
			$this->tableColumnsCache[$tableName][$ar["COLUMN_NAME"]] = $ar;
		}
	}
	return $this->tableColumnsCache[$tableName];
}