Microsoft SQL Server doesn’t seem have a describe command and usually, folks seem to want to build a stored procedure to get the describe behaviors. However, this is not always practical based on your permissions. So, the simple SQL below will provide describe like information in a pinch. You may want to dress it up a bit; but I usually just use it raw, as shown below by adding the table name.
If you want to describe a PureData / Netezza table in SQL, it can be done, but Netezza doesn’t have a describe command. Here is a quick SQL, which will give the basic structure of a table or a view. Honestly, if you have Aginity Generating the DDL is fast and more informative, at least to me. If you have permissions to access NZSQL you can also use the slash commands (e.g. \d).