Basic Windows SQL Server information commands

How to list the tables in a database (like show tables )

select name from DBAReporting..sysobjects where xtype = ‘U’;

How to show what is in a table ( list describe table )

select * from AIX_Servers where 0=1;

Leave a Reply

Your email address will not be published. Required fields are marked *