Symfony Profiler

SELECT
  col.name,
  type.name AS type,
  col.max_length AS length,
  ~col.is_nullable AS notnull,
  def.definition AS [default],
  col.scale,
  col.precision,
  col.is_identity AS autoincrement,
  col.collation_name AS collation,
  -- CAST avoids driver error for sql_variant type
  CAST(
    prop.value AS NVARCHAR(MAX)
  ) AS comment
FROM
  sys.columns AS col
  JOIN sys.types AS type ON col.user_type_id = type.user_type_id
  JOIN sys.objects AS obj ON col.object_id = obj.object_id
  JOIN sys.schemas AS scm ON obj.schema_id = scm.schema_id
  LEFT JOIN sys.default_constraints def ON col.default_object_id = def.object_id
  AND col.object_id = def.parent_object_id
  LEFT JOIN sys.extended_properties AS prop ON obj.object_id = prop.major_id
  AND col.column_id = prop.minor_id
  AND prop.name = 'MS_Description'
WHERE
  obj.type = 'U'
  AND obj.name != 'sysdiagrams'
  AND (
    obj.name = 'doctrine_migration_versions'
    AND scm.name = SCHEMA_NAME()
  )

SELECT                          col.name,
                          type.name AS type,
                          col.max_length AS length,
                          ~col.is_nullable AS notnull,
                          def.definition AS [default],
                          col.scale,
                          col.precision,
                          col.is_identity AS autoincrement,
                          col.collation_name AS collation,
                          -- CAST avoids driver error for sql_variant type
                          CAST(prop.value AS NVARCHAR(MAX)) AS comment
                FROM      sys.columns AS col
                JOIN      sys.types AS type
                ON        col.user_type_id = type.user_type_id
                JOIN      sys.objects AS obj
                ON        col.object_id = obj.object_id
                JOIN      sys.schemas AS scm
                ON        obj.schema_id = scm.schema_id
                LEFT JOIN sys.default_constraints def
                ON        col.default_object_id = def.object_id
                AND       col.object_id = def.parent_object_id
                LEFT JOIN sys.extended_properties AS prop
                ON        obj.object_id = prop.major_id
                AND       col.column_id = prop.minor_id
                AND       prop.name = 'MS_Description' WHERE obj.type = 'U' AND obj.name != 'sysdiagrams' AND (obj.name = 'doctrine_migration_versions' AND scm.name = SCHEMA_NAME());

SELECT
  idx.name AS key_name,
  col.name AS column_name,
  ~idx.is_unique AS non_unique,
  idx.is_primary_key AS [primary],
  CASE idx.type WHEN '1' THEN 'clustered' WHEN '2' THEN 'nonclustered' ELSE NULL END AS flags
FROM
  sys.tables AS tbl
  JOIN sys.schemas AS scm ON tbl.schema_id = scm.schema_id
  JOIN sys.indexes AS idx ON tbl.object_id = idx.object_id
  JOIN sys.index_columns AS idxcol ON idx.object_id = idxcol.object_id
  AND idx.index_id = idxcol.index_id
  JOIN sys.columns AS col ON idxcol.object_id = col.object_id
  AND idxcol.column_id = col.column_id
WHERE
  (
    tbl.name = 'doctrine_migration_versions'
    AND scm.name = SCHEMA_NAME()
  )
ORDER BY
  idx.index_id,
  idxcol.key_ordinal

SELECT                       idx.name AS key_name,
                       col.name AS column_name,
                       ~idx.is_unique AS non_unique,
                       idx.is_primary_key AS [primary],
                       CASE idx.type
                           WHEN '1' THEN 'clustered'
                           WHEN '2' THEN 'nonclustered'
                           ELSE NULL
                       END AS flags
                FROM sys.tables AS tbl
                JOIN sys.schemas AS scm
                  ON tbl.schema_id = scm.schema_id
                JOIN sys.indexes AS idx
                  ON tbl.object_id = idx.object_id
                JOIN sys.index_columns AS idxcol
                  ON idx.object_id = idxcol.object_id
                 AND idx.index_id = idxcol.index_id
                JOIN sys.columns AS col
                  ON idxcol.object_id = col.object_id
                 AND idxcol.column_id = col.column_id WHERE (tbl.name = 'doctrine_migration_versions' AND scm.name = SCHEMA_NAME()) ORDER BY idx.index_id, idxcol.key_ordinal;

SELECT
  f.name AS ForeignKey,
  SCHEMA_NAME (f.SCHEMA_ID) AS SchemaName,
  OBJECT_NAME (f.parent_object_id) AS TableName,
  COL_NAME (
    fc.parent_object_id, fc.parent_column_id
  ) AS ColumnName,
  SCHEMA_NAME (o.SCHEMA_ID) ReferenceSchemaName,
  OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
  COL_NAME(
    fc.referenced_object_id, fc.referenced_column_id
  ) AS ReferenceColumnName,
  f.delete_referential_action_desc,
  f.update_referential_action_desc
FROM
  sys.foreign_keys AS f
  INNER JOIN sys.foreign_key_columns AS fc
  INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id ON f.OBJECT_ID = fc.constraint_object_id
WHERE
  (
    OBJECT_NAME(f.parent_object_id) = 'doctrine_migration_versions'
    AND SCHEMA_NAME(f.schema_id) = SCHEMA_NAME()
  )
ORDER BY
  fc.constraint_column_id

SELECT                f.name AS ForeignKey,
                SCHEMA_NAME (f.SCHEMA_ID) AS SchemaName,
                OBJECT_NAME (f.parent_object_id) AS TableName,
                COL_NAME (fc.parent_object_id,fc.parent_column_id) AS ColumnName,
                SCHEMA_NAME (o.SCHEMA_ID) ReferenceSchemaName,
                OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
                COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName,
                f.delete_referential_action_desc,
                f.update_referential_action_desc
                FROM sys.foreign_keys AS f
                INNER JOIN sys.foreign_key_columns AS fc
                INNER JOIN sys.objects AS o ON o.OBJECT_ID = fc.referenced_object_id
                ON f.OBJECT_ID = fc.constraint_object_id WHERE (OBJECT_NAME(f.parent_object_id) = 'doctrine_migration_versions' AND SCHEMA_NAME(f.schema_id) = SCHEMA_NAME()) ORDER BY fc.constraint_column_id;

SELECT
  DB_NAME()

SELECT DB_NAME();

SELECT
  collation_name
FROM
  sys.databases
WHERE
  name = DB_NAME()

SELECT collation_name FROM sys.databases WHERE name = DB_NAME();

SELECT
  name AS table_name,
  SCHEMA_NAME(schema_id) AS schema_name
FROM
  sys.objects
WHERE
  type = 'U'
  AND name != 'sysdiagrams'
ORDER BY
  name

SELECT name AS table_name,
       SCHEMA_NAME(schema_id) AS schema_name
FROM sys.objects
WHERE type = 'U'
  AND name != 'sysdiagrams'
ORDER BY name;

SELECT
  tbl.name,
  p.value AS [table_comment]
FROM
  sys.tables AS tbl
  INNER JOIN sys.extended_properties AS p ON p.major_id = tbl.object_id
  AND p.minor_id = 0
  AND p.class = 1
WHERE
  SCHEMA_NAME(tbl.schema_id) = N 'dbo'
  AND p.name = N 'MS_Description'
  AND tbl.name = N 'doctrine_migration_versions'

SELECT
            tbl.name,
            p.value AS [table_comment]
          FROM
            sys.tables AS tbl
            INNER JOIN sys.extended_properties AS p ON p.major_id=tbl.object_id AND p.minor_id=0 AND p.class=1 WHERE SCHEMA_NAME(tbl.schema_id) = N'dbo' AND p.name = N'MS_Description' AND tbl.name = N'doctrine_migration_versions';

SELECT
  *
FROM
  doctrine_migration_versions

SELECT * FROM doctrine_migration_versions;