SELECT TABLE_SCHEMA, TABLE_NAME, VIEW_DEFINITION FROM...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--SELECT  COLUMN_NAME, DATA_TYPE, IS_NULLABLE 
--                FROM    INFORMATION_SCHEMA.COLUMNS AS c
--                WHERE   c.TABLE_NAME = 'Posts'
--                ORDER BY c.COLUMN_NAME

SELECT TABLE_SCHEMA,
 
   TABLE_NAME,
 
   VIEW_DEFINITION
 
FROM INFORMATION_SCHEMA.VIEWS
 
ORDER BY TABLE_SCHEMA,
 
   TABLE_NAME

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results