namespace Microsoft.Data.Entity.SqlServer.Design.ReverseEngineering.Model
{
    public class TableColumn
    {
        public const string Query = "SELECT\r\n    quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]\r\n  , quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]\r\n  , c.COLUMN_NAME [Name]\r\n  , c.ORDINAL_POSITION [Ordinal]\r\n  , CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]\r\n  , c.DATA_TYPE  AS [DataType]\r\n  , c.CHARACTER_MAXIMUM_LENGTH [MaxLength]\r\n  , CAST(c.NUMERIC_PRECISION as integer) [NumericPrecision]\r\n  , CAST(c.DATETIME_PRECISION as integer)[DateTimePrecision]\r\n  , CAST(c.NUMERIC_SCALE as integer) [Scale]\r\n  , CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]\r\n  , CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) as bit) as [IsStoreGenerated]\r\n  , c.COLUMN_DEFAULT as [Default]\r\n  FROM\r\n  INFORMATION_SCHEMA.COLUMNS c\r\n  INNER JOIN\r\n  INFORMATION_SCHEMA.TABLES t\r\n  ON c.TABLE_CATALOG = t.TABLE_CATALOG\r\n  AND c.TABLE_SCHEMA = t.TABLE_SCHEMA\r\n  AND c.TABLE_NAME = t.TABLE_NAME\r\n  AND t.TABLE_TYPE = 'BASE TABLE'\r\n  AND t.TABLE_NAME <> '__EFMigrationsHistory'";
    }
}