PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...

Why are there INFOMATION_SCHEMA and catalog views in SQL Server that do very similar things? For example, to retrieve a list of tables in a database, I can do it via sys.tables or INFORMATION ...