asdfasdf

0

Please login or register to vote for this query.

(click on this box to dismiss)

Biology

Q&A for biology researchers, academics, and students

SELECT
      s.name AS SchemaName
     ,t.name AS TableName
     ,c.name AS ColumnName
 FROM sys.schemas AS s
 JOIN sys.tables AS t ON t.schema_id = s.schema_id
 JOIN sys.columns AS c ON c.object_id = t.object_id
 ORDER BY
      SchemaName
     ,TableName
     ,ColumnName;
    
 SELECT
      TABLE_SCHEMA AS SchemaName
     ,TABLE_NAME AS TableName
     ,COLUMN_NAME AS ColumnName
 FROM INFORMATION_SCHEMA.COLUMNS
 ORDER BY
      SchemaName
     ,TableName
     ,ColumnName;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results