Hi Guys, Can some one help me to retrieve the table name & column name data from SQL server DB I am trying to work with following code, can some one correct me . Thanks in Advance!! libname mydb oledb provider=sqloledb datasource=myservername properties=( "initial catalog"=mydbname ) prompt=yes schema=myschemaname ; Proc sql; create detailsTN as(select * from connect to mydb (select Table_name from information_schema.tables);); create detailsCN as (select * from connect to mydb (select Column_name from information_schema.tables);); quit;
... View more