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;
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;